how do find problems with referential integity?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leonieh - 13 Apr 2005 03:32 GMT

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

Reply to this Message

Mark M - 13 Apr 2005 04:03 GMT

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).

>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
[quoted text clipped - 4 lines]
> find the problem Is there anyway of getting Access to highlight the exact
> problem to me? Thanks

Reply to this Message