grouped codes - QV creating duplicates

[#1]

I have grouped codes on my QV document. They are product & ' - ' & product_dsc. And two other grouped codes. On these grouped codes there are duplicates being created.

For instance, I have 2 entries with 1 number concatenated with a description and another entry underneath with the number and no description. Ive attached my document, can anyone tell me what is going wrong? Thanks very much in advance

[#2]

I think if you resolve the synthetic table, it should get resolved. You have "MATERIAL" and "MATL_GROUP" in "COPA" and "material" table.

Regards,

Sajeevan

[#3]

Thanks for the reply, there's definitely problems with tables. Prob Hier seems to be in there on a number of occasions.

Each listbox should be linking up with one another also. I'll definitely have to re-consider the structure

[#4]

Thanks for the help. I moved the concatenated tables and hung them from the main table, this fixed the issue with my relationships.

[rrsrini2907]

Hi still if you want to create the same way as you did previously, you can try this code.

IF(Not IsNull(material_group_description),MATL_GROUP) & IF(Not IsNull(material_group_description),' - ' & material_group_description) as GB

Basically testing not null and concatenating.

Regards,

Srini.