The changes you requested to the table were not successful because they would create duplicate value

  • Thread starter Thread starter usaccess
  • Start date Start date
U

usaccess

how do I find which table /record is doing this - The changes you
requested to the table were not successful because they would create
duplicate values in the index, primary key, or relationship

My db design is as follows - there is a project table, a case sub table
and in turn the case sub table as a deliverables sub table.

My form has two subforms. It was working fine till yesterday. Today it
is giving me this issue.

I search for duplicate case ID's and did not find anything.

Please advise.

regards
US
 
You will not find duplicates as it is not allowing them. You must have been
either adding or editing a record that would result in duplicate.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate values in the index, primary key, or relationship messag 2
duplicate value error message - new issue 1
Duplicate values 4
How do I find the indices on a table in Access 2003? 4
Duplicate Records Problem 2
Data entry creating duplicate rows in table 3
8 tables - need 1 form 4
Dulpicate Record 6

Back
Top