Software·43,781 discussions

One-to-One Relationship

Locked

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?

Topic

Use unique index

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.

Wrong forum

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.

Acces isn’t really relational

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.

[Author]

Replies