Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion


One-to-One Relationship

By teacherkate ·
I have separated a very large Access 2000 table into several smaller ones and am now trying to establish relationships between them. I NEED to create a one-to-one relationship, but am unable to do so. Access will allow me to create a one-to-many, but not one-to-one. Can ANYONE help?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Use unique index

by ahar In reply to One-to-One Relationship

Build the two tables with an unique index on the columns and voila there is only a 1:1 relation possible.

Collapse -

Wrong forum

by deepsand In reply to One-to-One Relationship

This is a tech. problem, in search of a solution.

It properly belongs in "Technical Q&A," not in "Discussions."

Please re-post there.

Thank you.

Collapse -

Acces isn't really relational

by Tony Hopkinson In reply to One-to-One Relationship

You can define the tables with a common key OrderNo for instance and make it a unique index. Seeing as they can only be one of each OrderNo in each table, you've got the One and One Bit. Last I saw you can't enforde a relationship between two tables in access by use of the table definition though so 'To' is something you have to do in the aplication that maintains the records. It also pre-supposes that the record must exist in one of the tables before the other.

Related Discussions

Related Forums