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.
Book II
Chapter 6
Figure 6-7:
Any one
student can
be enrolled
in many
The same tables and same relationships link any given course to the
students who are enrolled in it, as shown in Figure 6-8.
Figure 6-8:
Any one
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.
Search JabSto ::

Custom Search