Microsoft Office Tutorials and References
In Depth Information
Creating Referential Integrity with Many-to-Many Relationships
For the sake of the example, suppose that the junction table is named
Enrollments, as in Figure 6-7. When looking at data in the tables, you see how
each record in the Enrollments table links a student to his or her courses.
The same tables and same relationships link any given course to the
students who are enrolled in it, as shown in Figure 6-8.
Although a many-to-many relationship is conceptually its own beast, Access
recognizes only one-to-many relationships. To set up referential integrity
among the tables, you don’t create a special many-to-many join. Rather, you
just connect the fields and enforce referential integrity on each join line, as
shown in Figure 6-9.