Procedure to Relate Tables

  1. Start Enterprise Manager
  2. Click + to expand SQL Server Group
  3. Click + to expand your server group
  4. Click + to expand your database
  5. Right click Diagrams, if none exits, otherwise double click diagram on right side of screen,

    6. Right click in diagram, chose Add Existing table and skip to step 8

  6. Click New Database Diagrams...
  7. Click Next>
  8. Click tables to be related
  9. Click Add button
  10. Repeat steps 8 - 9, until all tables to related have been chosen
  11. Click Next>
  12. Click Finish
  13. Click OK
  14. Click on the box in front of the foreign key column and drag it to the column in the related table

    15. (the row of foreign key will become highlighted)

  15. The Properties dialog box for the table will appear
  16. Enter relationship name in the Selected relationship box

    17. Relationship name should be primary table name _ (undersorce) foreign table name

    ex. primary table name: TCO88_WINNT_Logins

    foreign table name: TCO88_Server

    relationship name: TCO88_WINNT_Logins_TCO88_Server

  17. Verify the correct columns have been chosen for the primary and foreign key
  18. Click Close button
  19. Click the save button (small diskette)