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
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.
Figure 6-8:
Any one
course
contains
many
students.
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