how do find problems with referential integity?

[Guest]

I am new learner on Access. I have 2 tables that I have set up with a
relationship. I wanted to "enforce referential integrity" but I get an error
message saying it can't as it violates the rules. I have done my best to
locate the difference between the primery key and matching field, but cannot
find the problem Is there anyway of getting Access to highlight the exact
problem to me? Thanks

 

[Mark M]

You can try building a query using the wizard to "Find unmatched records".
Run the query on the table on the "Many" side (the foreign key) of the
relationship to look for values that don't exist in the table on the "One"
side (the primary key).