Duplicate showing in query when there shouldn't be
"Fred" wrote:
I sure that this is just a less expert way of saying what Karl already said,
but, each of your relationship lines has to have a "no duplicates" field at
one end of it. 99% of the time the "no duplicates" field is a Primary Key
field, and making it a primary key is a way to automatically prevent you from
entering duplicates.
Violating this is the most common cause of your problem.
|