What is a Many-To-Many Relationship in Access 2007, and how to I get around it if I created one already? In short, Access does not support multiple records in one table corresponding to multiple records in another table, hence the Many-Too-Many (pun intended Too) relationships issue. The solution is that it's best to create an intermediary table between two tables that you're tempted to create multiple relationships between the two. This intermediary, or junction table will bridge the gap between the two by holding copies or duplicates of both primary keys of the two tables with the Many-To-Many relationship issue. See it in action and purchase the videos!

Purchase the training video and you can see this in action for yourself!