Bring back records from two tables based on parameter

[AMJADJ]

Hi



I have a customer sales table and a customer notes table, on which I am designing a query. I have brought the two tables in without linking them and brought in the appropriate fields. The issue I have is as this is one query, if I have one order but 3 notes, I am getting the order replicated 3 times, the difference between each record is the note itself.

The end game is to create a report where the user types in the customer ID, it brings back sales and notes. Currently this is working off two queries, but the user has to type in the customer ID twice.

I have created a report where the sub report is linked with the master report by customer ID, but if there is a customer with no sales but notes, it brings back blank for both main report and sub report.

Hope this makes sense!
Thanks In Advance.

[orange]

Can you join your tables by CustomerId? Have you tried?
Please post the sql of your query.

[AMJADJ]

Yes, but you may have customers who we have sold to, but entered no notes and vice versa, hence why I did not join the two tables.
Thank you for your time in replying.

[orange]

Your "hence assumption" is causing you grief.
Check this w3shools link for various Joins
Good luck