Creating Table Relationships in Access 2007
Now that you have the SHOW TABLE windows open, you can begin building relationships between tables. Building a relationship takes nothing more than a few clicks of the mouse. However, don’t be fooled into thinking that such as simple task does not create powerful relationships. Relationships are the heart and soul of a relational database.
To build a relationship between two tables, click on the first table in the SHOW TABLE windows and then click on the ADD button. This places the table and its contents in the RELATIONSHIPS area in Access 2007 (see Figure 3).
Now click on the second table in the SHOW TABLE window and then click on the ADD button again. This places the second table and its contents in the RELATIONSHIPS area of Access 2007.
To build a relationship, both tables must have a related field which is normally the primary key. To build the relationship, simply drag the related field from the parent table to the related field in the child table. When you do this, the EDIT RELATIONSHIPS window opens where you can modify the options of the relationship. When you have finished selecting your options, click on the CREATE button. If you did everything correctly, you should see a line between the two tables signifying that a relationship has been established (see Figure 4).