Center for Academic Computing:

A many-to-many relationship cannot be created directly in MS Access. To relate such tables, you must first create a junction table that contains the primary keys of both tables Junction table a table which has a primary key that’s actually a combination of at least the primary keys from two or more tables; a junction table acts as a bridge ... ................
................