Junction Tables

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

The examples for handeling many to many relationships (Access 2007) show the
creation of a junction table that includes 2 primary keys in one table, how
is this done?
 
The examples for handeling many to many relationships (Access 2007) show
the creation of a junction table that includes 2 primary keys in one
table, how is this done?
Click to expand...

No it contains ONE primary key consisting of multiple fields. Some of
those fields are foreign keys to one of the other tables and the others
are foreign keys to the remaining one.

Example...

Table1: PK=ID_1

Table2: PK=ID_2

Junction Table
Table3: PK= ID_1, ID_2
 
The examples for handeling many to many relationships (Access 2007) show the
creation of a junction table that includes 2 primary keys in one table, how
is this done?
Click to expand...

It's *one* primary key consisting of two fields.

To create such a primary key, open the table in design view. Ctrl-click the
two (up to ten, actually) fields so they're both highlighted; then click the
Key icon on the toolbar.
 
Back
Top