Re: Showing Optionality in a Relationship Diagram

Tech-Archive recommends: Fix windows errors by optimizing your registry

Did you try "Database=>Options=>Document=>Relation" ?

Enjoy with Visio
"Amy E. Baggott" <AmyEBaggott@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message de news:FF506520-6132-4D1D-BB7C-1459928EC8A7@xxxxxxxxxxxxxxxx
I am trying to create an ERD for an existing Access database. I've imported
the tables, and I am now trying to create the relationships I want. I can
see how you set cardinality (1-1, 1-many, etc.), but I can't see how you can
set optionality and show it on the diagram (e.g., "Each COMPANY may have one
or more ORDERS" vs. Each ORDER must have one and only one TRACKING RECORD").
In the Database Design course I'm taking, my instructor says that it should
be shown using either a dotted line on the "may" end or a solid line on the
"must" end. So between COMPANY and ORDERS, there would be a line that is
dotted on the COMPANY end, but solid on the ORDER end, while in the second
example, the line would be solid all the way across. How would I do this in
Visio?
--
Amy E. Baggott

"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson

.

Relevant Pages