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

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
 
G

Guest

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.
 

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 value error message - new issue 1
Duplicate values in the index, primary key, or relationship messag 2
How do I find the indices on a table in Access 2003? 4
Data entry creating duplicate rows in table 3
Duplicate Records Problem 2
Duplicate values 4
The changes you requested to the table werenot successful ........ 1
There is no duplicate, so why does access tell me there is? 3

Top