How to: Create Relationships Between Tables on a Diagram (Visual Database Tools)
You can create relationships between columns in different tables in the Diagram Designer by dragging columns between tables. For more information about relationships, see Types of Table Relationships (Visual Database Tools).
To create a relationship graphically
In Database Designer, click the row selector for one or more database columns that you want to relate to a column in another table.
Drag the selected column(s) to the related table.
Two dialog boxes appear: Foreign Key Relationship and Tables and Columns, with the latter appearing in the foreground.
Relationship name has a system-provided name in the format FK_localtable_foreigntable. You may change this value.
Verify that Primary key table specifies the correct table.
The grid lists the local columns and their matching foreign columns. You can add or remove table columns or change mappings.
The Foreign Key Relationship dialog box appears. Selected Relationship shows the relationship you have created.
Change properties for the relationship in the grid.
Choose OK to create the relationship.
Database Designer shows a relationship between the columns you chose.