If the direction of a join is incorrect, it can be changed by right-clicking on the join and choosing Flip direction.
REPLACE WITH THIS IMAGE: Images/Relationships/Changing the Direction of a Join.png
To change the direction of a join where multiple relations are shown as one link in the diagram...
- Right-click on the link and choose Flip direction:
REPLACE WITH THIS IMAGE: Images/Relationships/Changing the Direction of a Join_1.png
- From the Choose foreign key join dialog, select the relation from the drop-down list and click OK:
REPLACE WITH THIS IMAGE: Images/Relationships/Changing the Direction of a Join_2.png