General discussion

  • Creator
  • #2177096

    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?

All Comments

  • Author
    • #3351725

      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.

    • #3351522

      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.

    • #3351489

      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.

Viewing 2 reply threads