Excellent. Thank you osy45.

I couldn't see why such a relationship could not exist, but did not feel confident with the results that Access was giving me - duplicating the ROLES table so that there was two single relationships between the Associate attributes and RoleID.

ie

Original ROLES table
ROLES.RoleID <-> ASSOCIATES.PrimaryAssociate

Duplicated ROLES table
ROLES(1).RoleID <-> ASSOCIATES.SecondaryAssociate