I do not quite understand this property. Everything is clear to me,
when I read the corresponding help text.

But in practice I have a question: Why are there 3 identical records
in the following query (with property 'Unique records' = Yes)?

SELECT DISTINCTROW tblCustomer.[Customer ID], tblCustomer.[Company
Name], tblCustomer.[Locatiion Code], tblOrders.[Customer ID],
tblOrders.[Order ID], tblOrders.Artikel
FROM tblCustomer INNER JOIN tblOrders ON tblCustomer.[Customer ID] =
tblOrders.[Customer ID];

Can you help me? Thanks.

Beat Scheidiger