SteveCulshaw
Programmer
How do you know what Foreign key is which in a ER diagram?
- I've used the Database Model Diagram to create an ER diagram of a database, and some tables have more than one foreign key. OK, the diagram has these marked as FK1, FK2, etc. and if I select each relationship I can see in Database Properties which field is the foreign key, but can I determine this by just looking at the diagram?
Alternatively, is there someway to add the field name to the relationship shape, so it appears on the printout?
- I've used the Database Model Diagram to create an ER diagram of a database, and some tables have more than one foreign key. OK, the diagram has these marked as FK1, FK2, etc. and if I select each relationship I can see in Database Properties which field is the foreign key, but can I determine this by just looking at the diagram?
Alternatively, is there someway to add the field name to the relationship shape, so it appears on the printout?