One-to-one

[Bee]

Hi,

I have read several posts about one-to-one relationships and that they are very rare. My question is: if the FK is usually in the many side, how can you have a one-to-one relationship?

Any help will be very much appreciated.
B

 

[Len Boorman]

The answer really is that the FK is in the related table. You then define the relationship as 1:M or 1:1#

The FK does not define the degree of relationship

Len

 

[RCurtin]

Access determines whether the relationship is one-to-one or one-to-many depending on the two fields you are joining.
If the key in the related table is also a primary key or it is indexed as a unique key (i.e. indexed is set to yes with no dublicates) the relationship is one-to-one.

 

[Bee]

Access determines whether the relationship is one-to-one or one-to-many depending on the two fields you are joining.
If the key in the related table is also a primary key or it is indexed as a unique key (i.e. indexed is set to yes with no dublicates) the relationship is one-to-one.

That's great thanks. I noticed that Access decides what of relationship it's, I just could not think of how to join two table if I want to have a one-to-one relationship.