Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there a way to manually edit the cardinality/multiplicity symbols on the end of a database ERD made in Visio? The category I'm using is in Visio 2003 under Database -> Database Model Diagram

I want to be able to go from something like this:

alt text

To this:

alt text

The second graphic was done by manually adding the numbers, but I would prefer to just do it in Visio. Is there any way of accomplishing this?

share|improve this question
add comment

2 Answers

up vote 4 down vote accepted

Open up your diagram, and goto Database - Options - Document... on the menu bar. From there, access the Relationship tab.

You need to enable the Cardinality option, which (making an assumption here from your first diagram) you will probably have to disable the Crows Feet option to be able to use.

You set the numbers using the options within the Database Properties window/pane when editing the diagram.

share|improve this answer
add comment

In visio 2013: Right click the connector Choose "Show multiplicity" and number boxes appear

You can do this in Chen's notation - you don't need Crows Foot.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.