Relationship Type

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Object dependencies vs. relationships 4
Relationship must be on the same number of fields with the same... 9
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Complicated relationship between two tables 2
Referential integrity and join type 2
Table Relationships: An Understanding is necessary... 8
How to manually select relationship type in Access 2007 5
linking tables and relationships 3

Back
Top