Customer Records duplicated according to how many orders are in the subform

[ruth m]

I have a Customer Details form which has two tabbed pages on it – one of which has a subform with a list of that particular customer’s orders on it. For some reason, when scrolling through the records of Customer Details, any customers who have placed more than one order will appear as many times as they have placed orders. So for example, Customer A has placed two orders, and appears as two records in Customer Details. Customer B has placed four orders, and appears as four records in Customer Details. Each Customer Details record has all the relevant orders mentioned on the Order List on the tab page, but it (each Customer Details record) is unnecessarily being repeated as many times as there are orders. How can I stop this from happening?

[MMcCarthy]

The problem here is the query behind the customer details form. Somehow you have included something like OrderID which is duplicating the records.

I assume the relationship between orders and customers is CustomerID which should be a foreign key in the orders table. And therefore CustomerID would be the field you would use to link the customer orders subform to the customer details form.

[NeoPa]

SQL JOINs may be of use to you.