Let’s revisit a popular aspect to your Microsoft Access Tutorial database design; Creating a many-to-many relationship. Firstly, watch this quick video which explain the key components and the starting steps to getting to the many-to-many state for your Access database. In order to create this type of relationship, it’s now clear we need an interceding or junction table to handle the two-way joins of the outer tables with the option of setting referential integrity option which tightens the operational side […]

Tags: access database relationships, building access tables, how create a many to many database, many to many tables in ms access, ms access primary keys