If you want to create relationships in your SQL Server 2005 database diagram:
- Right-click the table that contains the foreign key (FK) in the forthcoming relationship.
- To create the relationship, click the ellipsis (...) box to the right of "Tables and Columns Specification". (This is quite hard to see.)
- In the Tables and Columns dialog, you can now select the tables, FK, and PK (Primary Key) that will participate in the relationship.