Visio database diagrams, associating columns

You can use the Visio Drawing tools to force the Relationship Connector to glue to particular Connection Points on the Table Shapes:

1. Turn on Connection Points in the View menu.
2. On the standard toolbar find the Connector Tool just to the right of the Pointer Tool. Click on the little arrow and change to the Connection Point Tool.
3. Hold Ctrl and click on one of the Table Shapes at the point where you want to join the Relationship Connector.
4. Do the same on the other Table Shape.
5. Glue the ends of the Relationship Connector to the Connection Points you just added.
6. You will have broken the relationship. To fix it, select the Relationship Connector and view the definition of the relationship in the Database Properties Window.
7. Associate the fields again.

(This was tested with Visio Enterprise 2003.)

If you click on the relationship arrows, green midpoints will appear. You can use these to drag the relationship arrow up and down. Be careful not to move the endpoints, though, because Visio will disassociate that connector from the table object.

To my knowledge this is how visio draws it, and it is not possible to get it to point at an exact column. its kinda annoying, but I guess you learn to live with the FK markings