daniel z Posted April 4, 2006 Share Posted April 4, 2006 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 Link to comment Share on other sites More sharing options...
Ender Posted April 4, 2006 Share Posted April 4, 2006 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 More sharing options...
daniel z Posted April 4, 2006 Author Share Posted April 4, 2006 ok thanks Ender Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6597 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 accountSign in
Already have an account? Sign in here.
Sign In Now