Trying to save a many to many relationship in Access

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

Guest

I have all other relationships saved but one. It's a part of a many to many
relationship. From what I understand that means it is actually two one to
many relationships. One of them works and saves the other works but it
doesn't save. I am using Access through windows XP
 
Dizz said:
I have all other relationships saved but one. It's a part of a many to many
relationship. From what I understand that means it is actually two one to
many relationships. One of them works and saves the other works but it
doesn't save. I am using Access through windows XP
Click to expand...

This is a quote from Access 2002 help:

"In a many-to-many relationship, a record in Table A can have many matching
records in Table B, and a record in Table B can have many matching records
in Table A. This type of relationship is only possible by defining a third
table (called a junction table) whose primary key consists of two fields -
the foreign keys from both Tables A and B. A many-to-many relationship is
really two one-to-many relationships with a third table."

If you look it up, there's also an example with a diagram.
 
When you have a many to many relationship means your Table1 can have many
matching records in Table2... and Table2 can have many matching records in
Table1. To fix this you need to make a third table that combines the two
together. To do this, you need to create the table and then add the Foreign
Keys from both tables (which are your primary keys in both the tables your
trying to connect)
Then that should allow you to setup a one to many relationship all the way
through.
 
Back
Top