Creating Relationships in Microsoft Access 2007

You'll now see the blank relationship diagram, as shown in the image above.

In our example, we'll be creating a relationship between the Routes table and the Runs table. As you can see, we've added both of those tables to the diagram. Notice that there are no lines joining the tables; this indicates that you do not yet have any relationships between those tables.