D
dab1477
After successfully running a database for 2 years, suddenly as of 1/20/2010,
I get the following error message after data input into a form, "The changes
you requested to the table were not successful 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".
I am inputing about 13 values into a form that feeds a master table. The
table can have duplicate values, but NOT within the same date and shift
input, I have reviewed the ID or Primary key of the 11644 records within the
table and have found no duplicates. As this database has worked successfully
for 2 years, I doubt that someone has, or would know how, to address the
database relationships. Can somone point me in the right direction please?
I'm an intermediate Access junkie and am now frustrated. Thanks for any help
you can provide,
I get the following error message after data input into a form, "The changes
you requested to the table were not successful 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".
I am inputing about 13 values into a form that feeds a master table. The
table can have duplicate values, but NOT within the same date and shift
input, I have reviewed the ID or Primary key of the 11644 records within the
table and have found no duplicates. As this database has worked successfully
for 2 years, I doubt that someone has, or would know how, to address the
database relationships. Can somone point me in the right direction please?
I'm an intermediate Access junkie and am now frustrated. Thanks for any help
you can provide,