Cannot see relationships, just the join type icon.

[mnongkhlaw]

Hi all,

This is my first post.

In the database diagram pane, I can see only the join type icon, but I cannot see the relationship (one-to-many etc.)

What's the reason/solution?

Regards,

Mark.

 

[MerlinB]

Don't know what you mean. Right click the background, and you can tick the 'Show Relationship Labels' option.

All database relationships are one-to-many. We can emulate a many-to-many by using a middle table. A one-to-one relationship is logical only - enforced by code if required.

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)