Show the relation into the relations windows on Access 2007

M

MDelisle

We use now Access 2007 and when we build the relations between tables we
don't see the relation number above the line between tables as Access 2000
(the "1" and / or "infinite number". Is is possible to shown these
information on the Relations window?
 
A

Allen Browne

The "1" and "many" should appear in the Relationships window as it did in
previous versions.

They don't appear if the relation does not have Referential Integrity
enforced.

They may not appear correctly if you are not looking in the database where
the relationship exists (i.e. if you are looking at attached tables.)
 
Top