Forcing a one to one relationship

[mama16]

First of all, I'd like to say hi to all you people.
I have a bunch of tables that are all linked. There is a one to many link that I'd like to change it to a one to one.
How do I go about doing that? On the E-R diagram session, when I drag the field (PK) to the other table (foreign) Access makes it a one to many. It's not possible cause on my design one business has one contact person and not many.

Any suggestions?

 

[RoyVidar]

The relationship created by the "drag 'n drop" interface, is determined by the index of the fields in question.

If the fields on both sides are indexed with "yes no dupes", then it creates a 1:1 relationship.

Is one is "no dupes" the other with "dupes OK" or no index, then it creates a 1:M relationship.

If none of the fields have a unique index, it says "indeterminate".

Often, in a 1:1 relationship, you use the same field as primary key in both tables.

Roy-Vidar