Access: Setting up relationships

Here is a pretty good guide to creating relationships in Access.  NOTE that the relationship between Students and Courses in this example is M:N...thus the Enrollment table is created to break up that many to many into TWO one to many relationships.  Further, while she suggests using Cascading update and delete, I usually hesitate with those, only because you can do more damage than good with those enacted.



I would look over pages 807-844 in your book.