Referential Integrity

[bsdixon]

I am trying to set up the relationships for the tables in my database. I have two tables that have a one to many relationship. When I try to enforce referential integrity I get an error message that says there are records that are not in my primary table.

Is there anyway to quickly find these problem records without searchs through all of the records in my "many" table?

Thanks

 

[Rich]

Use the FindUnmatched query wizard