Hello all,
I have a form with a subform on it. The users cannot add a record to the subform all of sudden. I went to a copy of the database from last month and it worked there. I thought the query was a not updateable query, so I copied the sql from the database that worked into the one that does not work and it did not change anything. I checked the master child links and they are exactly the same for both. I have compared all that I can and still see no differences, but continue to get the below error;
The changes you requested to the table were not succesful because they would create duplicate values in the index, primary key, or relationship,. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
The tables looked to be the same, so I must be missing something. Anyone have any ideas.
Thank You
Jim Wagner
Tidak ada komentar:
Posting Komentar