Making a one to one relationship

[micromoth]

Access 2003 automatically selects the relationships now. in Access
2000 it used to be a dropdown box to select a one to one relationship
when right click the relationship line. How do I now change a one to
many relationship between a Primary key and a Foreign key.
cheers in advance.

 

[Douglas J Steele]

AFAIK, nothing has changed with respect to how you create relationships.

To make a relationship one-to-one, the field(s) involved in the relationship
must be the Primary Key for both tables.

 

[John Vinson]

AFAIK, nothing has changed with respect to how you create relationships.

To make a relationship one-to-one, the field(s) involved in the relationship
must be the Primary Key for both tables.

.... or at least have a unique Index.

John W. Vinson[MVP]

 

[Douglas J Steele]

... or at least have a unique Index.

Yes, true. Thanks for the reminder.