Remove From My Forums

How do I construct a junction tables with foreign keys?

Question
0

Sign in to vote

User-1885804455 posted

Since a junction table is used for tying two tables together, then it seems logical to only have respectively primary keys as foreign keys in the junction table.

Is it possible to create a table in Access with only two foreign keys, and NO primary key?

Sunday, March 13, 2016 12:58 AM

Answers

0

Sign in to vote
User541108374 posted

Hi,

you can leave out the primary key column in the junction table and take the columns of both foreign keys as a surrogate primary key. Note that it has consequences though. This article explains it nicely with pros and cons: http://en.tekstenuitleg.net/articles/software/create-a-many-to-many-relationship-in-access.

Grz, Kris.
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Sunday, March 13, 2016 8:30 AM