Relationships Cont'd

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

Guest

When I try and relate it automatically sets it as a one to one
relationship...Dont I need a one to many relationship?
 
If it automatically sets up a 1-1 relationship, you are joining the primary
keys of the two tables. You should be able to see that they are in bold.

For a 1-M relationship you need to join the Primary Key in one table to the
Foreign Key in the other.
 
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

Relationship Help 4
Relationships 7
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
One To Many Relationships - Series of Related Tables 9
Referential Integrity for Lookup fields in tables 7
Making a one to one relationship 3
for an ebike biz: Northwind without existing customers etc 0
Relationship deleted but still added when a new query is made 2

Back
Top