Why are records repeating in my query results?

[repeating records in my query results!]

I am a self-taught Access user, still new at this stuff... so some of the
vocabulary is a challenge for me.

I'm doing a query using field from two tables in my database which have the
following:

A unique identifer (primary key) in each table.
A field that links them in a...
A one-to-one relationship

The results should contain 279 records.
They contain 434 records.
The first 10 records are OK, then records start repeating. Wierd.

What could cause this?

Thanks,
Edith

 

[repeating records in my query results!]

I solved it, thanks anyway!
-Edith

 

[John Spencer]

First are you linking the two tables on fields that have unique values?

Simple (and perhaps unneeded) discussion follows.

Lets say you have two tables with the following records in Table1.FieldA and
Table2.FieldB

Table1 FieldA values
A
B
C
D

Table 2 FieldB Values
A
A
A
B
C
C
D

If you link Table1.FieldA to Table2.FieldB you will get back 7 records.
A A
A A
A A
B B
C C
C C
D D

The "duplicates" are caused because the A in TableA links to the 3 records
with A in TableB and the C in TableA links to 2 records in TableB.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County