Query results in duplicate records data

[Farman Khan via AccessMonster.com]

Hi
i have designed a query based on two tables
it generates a recordset that contains the same data multiple times
how to block it?

 

[Wayne Morgan]

I'm guessing that you don't have a link between the tables. Without a link,
you will get a Cartesian product of the tables (you will get each record
from the second table for each record in the first table).