Missing records on the One side of a One to Many relationship

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have somehow managed to get some extra records in the many side of a one to
many relationship. As I have thousands of records is there an easy way to
identify these records so I can add the one side?
 
First check to see if you truly only have one record in your "one" table. My
best guess would be you have multiples in that table. To check make a query
using the "one record" table. Have the joined field listed twice and use the
count function. In the criteria put >1. This will show you if you have
multiple records in your "one record" table.
 
I have somehow managed to get some extra records in the many side of a one to
many relationship. As I have thousands of records is there an easy way to
identify these records so I can add the one side?
Click to expand...

This should be impossible if you in fact have a defined relationship
with referential integrity enforced. What is the Primary Key of the
"one" table? the "many" table? What is the Foreign Key? If you click
on the join line in the Relationships window, which boxes are checked?

You can use the Unmatched Values query wizard to create a query to
find these - but it sounds like you need to fix the relationship to
prevent such erroneous records from being entered in the first place.

John W. Vinson[MVP]
 
Back
Top