This content has been marked as final. Show 2 replies
On the following code the field 'CatEDesc' does not hold any data. In my QV app when I select a listbox with the value 'CatEDesc' nothing is returned under that value.
However if I have a listbox with 'MATERIAL DESCRIPTION' im given all the product descriptions. Am i missing something here, why cant the values from MATERIAL_DESCRIPTION be passed onto CatEDesc?
(In my table 'COPA', you have the MATERIAL_DESCRIPTION. There are no issues with this table.)
Any help would be greatly appreciated. Thanks
PROD_HIER as prod_h,
left(PROD_HIER,2)&'00000000' as CatACode,
left(PROD_HIER,4)&'000000' as CatBCode,
left(PROD_HIER,6)&'0000' as CatCCode,
left(PROD_HIER,8)&'00' as CatDCode,
MATERIAL_DESCRIPTION as CatEDesc