Resolving a Many to Many relationship in Access

In this tutorial we will resolve a many to many relationship by creating a Transaction Table. We will look at creating Duel Primary Keys and enforce the relationships.

We will then make lookups to help data entry and reduce user error in the next tutorial.