cannot enter new item..always got error

[celosia]

hi ..i got error with my access, why i cant enter new item,the maximum fill in new item for customer only 6 times(until order# 6), and when i enter the 7th (Order# 7)times i got error message " The Change You requested to the table were not successful because they would create duplicte value in the index, Primary Key, or relationship. Change the data in the field or fields that contain data, remove the index, or redefine the index permit enteris and try again"

What is this mean? help me

 

[Geoff Codd]

there must be a field in you table which is the primary key (Only unique records can be entered), one of the previous 6 records has the same unique ID as the seventh record you are trying to enter. so either remove the primary key or enter a unique value

 

[Pat Hartman]

The default setup of Access specifies the AUTOMATIC creation of unique indexes on fields whose names include certain prefixes or suffixes. I recommend that you turn this option OFF! Go to Tools/Options/Tables/Queries tab and clear the "Auto index on import create" box.

Then to undo the damage, you'll need to open each table in design view, open the indexes properties box and delete the extraneous indexes.

 

[celosia]

I have try to Clear the Auto index on import create box..But the Error message still asking the same error..why? Help me because Access is new for me..

 

[Pat Hartman]

You also need to delete the extraneous indexes that are already created.

 

[celosia]

Hi...im more confuse..is this happen because i always delete the previous input that i have enter?In the Order Table i use the autonumber for my OrderNumber(primary key),so before this i have try enter input to try the Order Form, but i have delete the record until 12 times, (order#= 12)because some mistake.So when i try enter the next record, the autonumber also dose not working and still ask the same error message..What is the problem i still dont understand because Access is new for me..Help..