Junction Tables

[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?

 

[Rick Brandt]

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?

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

 

[John W. Vinson]

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?

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.