Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Create Relationship - Help Please?

Author  Topic 

JBelthoff
Posting Yak Master

173 Posts

Posted - 2001-07-14 : 13:26:09
Hi,

I am trying to create a relationship in a database diagram. However when I follow the instructions from BOL and click the row selector then move the mouse outside no line appears. How does one do this.

I know I must be doing something really stupid but I'm stumped.

You help is greatly appreciated. Thanks

JB


FROM BOL
To create a reflexive relationship

1. Open a database diagram.

2. Click the row selector for the database column that you want to relate to another column.

3. While the pointer is positioned over the row selector, drag the pointer outside the table until a line appears.

4. Drag the line back to the selected table.
Release the mouse button.

5. The Create Relationship dialog box appears and attempts to match the primary key columns with the non-key columns you dragged the line to.

6. Confirm that the columns you want to relate are shown in the Primary key table and Foreign key table lists.




   

- Advertisement -