Last post Mar 13, 2016 08:30 AM by XIII
Mar 13, 2016 12:58 AM|Ptolemy|LINK
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?
Mar 13, 2016 08:30 AM|XIII|LINK
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: