Connection points on relationship diagram

[MikeB]

I'm working on defining the relationships between my tables. When I
drag the foreign key from one table onto the primary key of another
table, Access creates a connecting line between the two tables.
Sometimes the connection point to the table is on the right of the
table diagram and sometimes on the left. Mostly it is fine, but in a
few vexing situations Access has created the connections such that
the connection point is on the left of one table and on the right of
the other table, causing the line to go behind one of the tables. I
cannot seem to find a way to change how the relationship is depicted

If what I say doesn't make sense, see this screenshot (http://
img.villagephotos.com/p/2006-12/1233551/Access-
relationshipdiagram.JPG) and note the red relationship line. I'd much
rather have it connect on the right or the left of both tables than
the staggered connection it has.

 

[Graham R Seach]

Mike,

There's nothing you can do about it; it's just the way Access does it.
Re-aligning the tables is the only thing you can do.

You can move Contacts down below Tournaments, then move AdminContacts and
States beneath ClubsTournaments. You'll probably then have to move Admins to
the left to see the line properly.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[MikeB]

Mike,

There's nothing you can do about it; it's just the way Access does it.
Re-aligning the tables is the only thing you can do.

You can move Contacts down below Tournaments, then move AdminContacts and
States beneath ClubsTournaments. You'll probably then have to move Admins to
the left to see the line properly.

Thanks. Is there some algorithm or meaning behind which side the lines
attach to or is it some "luck of the draw" type thing?

 

[Graham R Seach]

Mike,

Well, I wouldn't call it an algorithm, but if your table is to the right,
then the line comes out of the left, and if your table is to the left, the
line comes out of the right. If it's dead-centre, there would be a default,
but I really haven't paid that much attention to see which way it goes.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia