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?
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]