Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks for the help. I moved the concatenated tables and hung them from the main table, this fixed the issue with my relationships.
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.