Exporting related fields

[daniel z]

Hello !

I have a Contacts table, and Product_Summary table which basically just contains contactID and ProductName, summarising all the products a contact has.

I can export this information fine if I do it from the ProductName table, but it then excludes

all contacts who DO NOT have any products to their name - which is a problem for me.

I then tried to export this information from the Contacts table itself, and included the related product summary fields in. This solved the problem, but I now have another problem - the same one as Tewan in Topic#175387; ie I am getting

Contact 1 Product 1

Product 2

Product 3

Contact 2 Product 1

in my exported file instead of

Contact 1 Product 1

Contact 1 Product 2

Contact 1 Product 3

Contact 2 Product 1

Any ideas ?

Thank you !

Daniel

[Ender]

You can't have it both ways. Either export from the join table (Product_Summary) to get the format you specified, or export from the ProductName table to get all Products, whether or not they are used by a Contact.

[daniel z]

ok thanks Ender