In Visio 2010, how can I create a mandatory, non-identifying relationship between two database tables
Posted
by
Cam Jackson
on Super User
See other posts from Super User
or by Cam Jackson
Published on 2012-05-17T04:57:21Z
Indexed on
2013/10/26
22:02 UTC
Read the original article
Hit count: 335
I'm working in MS Visio 2010. This is the relevant part of my ERD: 
The relationship between Event and Adventure is correct: there's a foreign key from Event to Adventure, and that FK is part of Event's primary key.
However, what I can't figure out is how to make the relationship line from Adventure to AccomodationType be the same, without making that relationship part of the PK of adventure. When I look at the 'Miscellaneous' properties of that relationship line, I want it to be:
- Cardinality: Zero or more
- Relationship type: Non-identifying
- Child has parent: Not optional (mandatory)
But the checkbox for the third property is greyed out, and toggles between True/False as I make the relationship Non-identifying/Identifying.
The only way I could figure out was to disconnect the two columns, from the 'Definition' tab, which then un-grey's the 'Optional' checkbox, but then I lose the foreign key property on the accomType column, and while the relationship symbols are correct, the line remains dotted.
Any ideas, anyone?
© Super User or respective owner
