one to one relationship?

[shrndegruv]

I cannot set a one-one relationship ... Ive defined relationships, but when I bring up the edit box it always says one to many...how do I change relationships between table to be one to one?

 

[KenHigg]

Can you zip it down and post it?

kh

 

[kdm3]

The type of relationship specified is the only type possible with the data structure of the tables - a one-one rlationship can only be set-up between primary keys which match completely i.e. the number of PK fields have to match, if composite PKs are used.

If you're linking to a non-PK field, or only part of a PK then a one-many relationship will be possible. If you want a non-PK field to be unique, just set no duplicates, and then setup a one-many with the PK of the other table - which will act like a one-one.

Something I learned the hard way!?

 

[shrndegruv]

thanx -- that makes sense I guess.