none
One to many relationship turned into one to one relationship RRS feed

  • Question

  • I made a copy of my Access file. On that copy I have one table having a one-to-many relationship with all the other tables. On the original Access file, I decided to redo one of the tables. I deleted all records from the other tables to start anew. I am able to redo all one-to-many relationship except one that is now recognized as a one-to-one. Why is that happening?
    Tuesday, March 28, 2017 1:42 PM

Answers

  • Because you have a unique index on the foreign key field(s).

    -Tom. Microsoft Access MVP

    • Marked as answer by MarcusKgosi Wednesday, March 29, 2017 5:53 AM
    Tuesday, March 28, 2017 1:57 PM

All replies

  • Because you have a unique index on the foreign key field(s).

    -Tom. Microsoft Access MVP

    • Marked as answer by MarcusKgosi Wednesday, March 29, 2017 5:53 AM
    Tuesday, March 28, 2017 1:57 PM
  • We can't be of much help if you don't give us more details. Please post the structure of the 2 tables so we can see what you are dealing with.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Tuesday, March 28, 2017 1:57 PM
  • Thanks Tom, that worked. :)

    Why the index?

    Wednesday, March 29, 2017 5:53 AM