Duplicated records

[Steven811]

Hi

I want to create a simple record set from a query for use in a form. A query that looks at 2 tables, one for customer and the second for their sales so that the form ultimately displays all the sales for each customer.

The results from the query repeats the entry for the customer every time their is a corresponding sale.

How do I correct this?

Thanks in anticipation.

Steven811

PS - It's a one to many relationship

 

[Steven811]

Tab Control

The query is working exactly as it should. The 1-side data appears once for each occurance of the related-many side data.

When you have a 1-to-many relationship, the best solution is to use a query based on the 1-side as the RecordSource for the main form and a query based on the many-side as the RecordSource for the subform. Do not attempt to work with both tables in the same form.

Thanks for that.

I need to use another subform nested in the sales subform and the overall view is quite cluttered, I would like to use tab control in the form. I have found that this only works with one data source and when I use a query constructed from 3 tables, I have this problem of duplicate records that I can't resolve.