michigan informatics

Editing Relationships

Close the Show Table window by clicking on the Close button.  Click on the field in the main table that you want to use in the relationship, and drag it to the related field in the second table.  

The Edit Relationships window specifies which tables are related (1), and which fields they are related by (2). Note that if you did not have any data in your tables yet, Access would have no way to know the relationship type. 

Check the box labeled "Enforce Referential Integrity" (3). This means is that there cannot be a record in the Contacts table without a related record in the Participants table. This makes sense, because you cannot contact someone that does not exist.

At the bottom, "Relationship Type" reveals that this is a one-to-many relationship (4). Having this box checked means that there cannot be a record in the Contacts table without a related record in the Participants table.