Relationships between tables

[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

 

[Jeff Boyce]

Lisa

We aren't there. We can't see your tables. More specific descriptions of
what you have in the tables may lead to more specific suggestions.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[KARL DEWEY]

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

 

[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?

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]