Part 3 Junction Tables - Library System in Access 2010

To allow a many to many relationship between tables in a relational database you must create a middle table called a junction table. This table has two foreign keys one to each of the table where you wish to instantiate a many to many relationship.