Can someone help me with what I’m doing wrong here please?
I created a report joining 2 files to retrieve Customer #, Customer Name, Email address, and Date the Customer # was created. Joining the 2 files to include the Email address returns the same line multiple times for some customers, while other customers only return a single record.
What can I do to prevent the duplicate records?
Best answer by yhartman
View originalWhen joining two tables, you will get duplicates if one of the tables has duplicates. For instance, one customer can have multiple contacts, so you will get numerous results when joining a customer with various contacts.
If your goal is only to show a single record per customer with the default contact, you can join the table as follows defContactID Equal contactID.
I hope this helps.
Thank you SOOOO much! That completely fixed my issue.
I really appreciate it!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
