Referential Integrity in Queries

[Mandango]

I have 3 tables all linked with referential integrity. After upgrading to
Access 2007, the relationships are still enforced, but when I view a query,
the join does not show the referential integrity. This is all of the queries
by the way. If I delete the table and re-add it in the design view, it does
show the proper join, but is there a better way.

 

[Allen Browne]

A query join is quite different from a relation between the tables.

When you create a relation between tables, and then add the tables to the
query, Access usually does make the join for you. In fact when you create
the relation, you can tell it what kind of join to make if you wish, or even
have no join by default.

There are several cases where Access can't figure out what join to create in
queries. Examples: where you have multiple copies of the same table, where
the tables are aliased, or where there are conflicting factors Access has to
weigh up.

So, the short answer is that you are happily create the join manually if
Access did not do it the way you expected.