Query results in duplicate records data

  • Thread starter Thread starter Farman Khan via AccessMonster.com
  • Start date Start date
F

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?
 
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).
 
Back
Top