Create a many-to-many relationship in Access
A many-to-many relationships in a relational database exists when one record in table A can be referenced by one or more records in table B and one record in table B can be referenced by one or more records in table A. In this tutorial you will learn how to create a many-to-many relationship in Access 2010.