resident tables - values not being passed

[#1]

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

groupedCodes:

NOCONCATENATE LOAD

PROD_HIER as prod_h,

MATL_GROUP,

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

RESIDENT COPA

where len(PROD_HIER)=10;

[swuehl · Accepted solution]

Brianm10,

you probably checked that you have also MATERIAL_DESCRIPTION values in table COPA where len(PROD_HIER)=10?

[#3]

argh... my mistake

Thanks