Q: Referential Integrity

  • Thread starter Thread starter Geoff Jones
  • Start date Start date
G

Geoff Jones

Hi

I have two tables that I'm trying to get a one-to-many relationship. When I
try to impose Referential Integrity I'm told that there is an error i.e. I
think that there may be some fields that do not match up to the field in the
other table. My question is, how do I find the non matching fields in the
most efficient way?

Thanks in advance

Geoff
 
There is a "Find Unmatched" query wizard. Just run it and select the 2
tables in question.
 
Back
Top