Appendix to Lab 17:

Establishing Relationships

In order to enforce referential integrity and to be able to create your linked forms you must establish the relationships between your tables. They might be one-to-one or one-to-many or many-to-many. In order to ensure data integrity, allow Access to enforce the relationships as you create queries and forms.

1. After you have created the structures for all of your tables, go to the Relationships window by right-clicking on the Project 4 database window:

You will then see a window with all your tables displayed:

Drag the keys that correspond to each other from one table to the next. Once you have placed them, an Edit Relationships window comes up. Check the Enforce Referential Integrity window and Create the relationship:

When you have created all the proper relationships, your window should look like this:

Use the drag and drop method to show where the tables are associated

Save and close the Relationships Window. Now you will be able to build your Forms.