Jump to content

Exporting related fields


daniel z
 Share

This topic is 5724 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 :D

Contact 1 Product 1

Contact 1 Product 2

Contact 1 Product 3

Contact 2 Product 1

Any ideas ?

Thank you !

Daniel

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5724 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.