One-To-Many Relationship diagram tool

W

wnfisba

We have the need to indicate a one-to-many relationship between tables. Is
there a way in Visio to make a diagram relationship like this....

/
O-
\

Please let me know.

Thanks.
 
L

Leif

In a Database model diagram you can set the cardinality by selecting the
relation (the acctual line between the tables), and then go to the Database
properties dialog box. In the Miscellaneous section you will find the
cardinality. To have a one to many, you need to set it to either Zero or more
or One or more.

Tip: Visio, by default, displays the relation as an arrowed line. If you are
used to the crows foot notation, you can change this, to better visualize the
cardinality of the relationship. On the Database menu, select Options and
then Document. Go to the Relationship tab of the Database Document Option
dialog, and select crow's feet.

Hope this was of help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top