Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Many to Many relationship
- Thread starter mama16
- Start date
See the Help file at:
"Define relationships between tables"
"Create the two tables that will have a many-to-many relationship.
Create a third table, called a junction table, and add to the junction table new fields with the same definitions as the primary key fields from each of the other two tables. In the junction table, the primary key fields function as foreign keys. You can add other fields to the junction table, just as you can to any other table.
In the junction table, set the primary key to include the primary key fields from the other two tables. For example, in an Order Details junction table, the primary key would be made up of the OrderID and ProductID fields. "
Sam_F
"90% of the problem is asking the right question.
"Define relationships between tables"
"Create the two tables that will have a many-to-many relationship.
Create a third table, called a junction table, and add to the junction table new fields with the same definitions as the primary key fields from each of the other two tables. In the junction table, the primary key fields function as foreign keys. You can add other fields to the junction table, just as you can to any other table.
In the junction table, set the primary key to include the primary key fields from the other two tables. For example, in an Order Details junction table, the primary key would be made up of the OrderID and ProductID fields. "
Sam_F
"90% of the problem is asking the right question.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
