Relationship Type

D

dgreen

How does Access determine the relationship type between two tables in a
relationship? Two related tables brings up a one-to-one relationship where
it should be a one-to-many. Is there a way to change this? Thanks for your
help!
 
J

John Vinson

How does Access determine the relationship type between two tables in a
relationship? Two related tables brings up a one-to-one relationship where
it should be a one-to-many. Is there a way to change this? Thanks for your
help!
Click to expand...

It looks at the Indexes on the join fields. If you join two fields
which both have unique Indexes (such as when you join a Primary Key in
one table to the Primary Key in another table), Access will recognized
this as a one to one relationship. If you don't want a one to one,
change the index type's Unique Values property to False (if that's
appropriate for the index; if it's not, you may need a new field to
serve as a Foreign Key).

John W. Vinson[MVP]
 
Top