How do I Avoid creating duplicate values in access?

G

Guest

I have been given a list of inventory that I need to enter into our Access
database. I have five items that I can not enter in, because I get an error
message stating that I am "creating duplicate values in the index, primary
key, or relationship...". I know that these are NOT duplicate values, because
I have sorted through the database by hand and these items have not yet been
entered. I have an Asset ID and a Sticer ID...the sticker ID is what I have
been using to enter these fields in. I haven't been able to find away to get
around this error message. Any advice?
 

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
duplicates error after 2 years- why? 5
"Duplicate values in the index, primary key, or relationship" 2
Beginner- duplicate values and indexs 4
Data entry creating duplicate rows in table 3
Error Message 1

Top