Take the following steps to create a relationship:

   1. Run SQL Server Management Studio from Start – Programs – Microsoft SQL Server 2005 – SQL Server Management Studio.
   2. In the Connect to Server dialog box, click the Connect button.
   3. In the Microsoft SQL Server Management Studio window, double-click the Databases folder.
   4. In the Microsoft SQL Server Management Studio window, double-click the database.
   5. In the Microsoft SQL Server Management Studio window, double-click the Tables folder.
   6. Right-click the table and click Modify.
   7. The table will open in edit mode. Select the column for which a foreign key is to be assigned.
   8. Go to Table Designer – Relationships.
   9. The Foreign Key Relationships dialog box will open.
  10. In the Foreign Key Relationships dialog box, click the Add button to create the foreign key. Click the Browse button in the Tables and Columns Specification property.
  11. The Tables and Columns dialog box will open.
  12. Select the primary key table from the Primary key table dropdown list.
  13. Select the primary key column from the Primary key table dropdown list.
  14. Select the foreign key column from the Foreign key table dropdown list. Click the OK button.
  15. In the Foreign Key Relationships dialog box, click the Close button.
  16. In the Microsoft SQL Server Management Studio window, go to File – Save Customer (Customer is the name of the table.) to save the changes.