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?
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/968b1c97-4e8c-485e-88e1-86d9eb1574a5.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/18b4d5fa-6322-4c9d-8d3a-f88ba3314bf7.png)
Best answer by yhartman
View original