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 as the one from Event to Adventure, 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.
How can I make the cardinality of the line on the left appear the same as the relationship line on the right, without adding accomType to the PK of Adventure?