Relationships between tables

L

Lisa

When I try to build a relationship between 2 tables I get this message 'MA
cant create this relationship and enforce referential integrity' it suggests
my second table violates these rules, but I dont know why?

Can anyone out there help?

Thanks
 
K

KARL DEWEY

Create an unmatched query to find records in your many side that are not in
the one side of the relationship.
 
J

John W. Vinson

When I try to build a relationship between 2 tables I get this message 'MA
cant create this relationship and enforce referential integrity' it suggests
my second table violates these rules, but I dont know why?

Can anyone out there help?
Click to expand...

Not without more information, no.

There is apparently some data in your tables which violates the relationship;
for instance you might have some records in the "many" side table with a
foreign key field (the field you're trying to join on) which does not exist in
the "one" side table.

Since we can't see your tables we can't find that record for you - you'll need
to use a Query (the Unmatched Query Wizard can build one for you) to do so
yourself.

John W. Vinson [MVP]
 
Top