Error Updating Table with Duplicate Information

[JockVSJock]

I've created a database based off of three tables that tracks
what I buy for groceries. There is a main table which tracks the item and then the price and the location.

I've set it up under the index on each table to allow for duplications.

When I enter in a duplicate entry into a form that collects the information, I receive this output:

"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 allow for duplicate entries."

Can anyone tell me why I am receiving this output?

thanks

-Chris

 

[Rolliee]

Your table has fields that allow no duplicates. Your input data has entries that would cause then to be added - as duplicates and your told ACCESS not to allow dupes. It (ACCESS) is only doing what you asked.

Rollie E

 

[JockVSJock]

My bad....

I forgot I needed to change the index for all fields, not just for one or two fields.

thanks

-Chris

 

[JockVSJock]

My bad....

I forgot I needed to change the index for all fields, not just for one or two fields.

thanks

-Chris

 

[Garridon]

If your design change doesn't fix it, it also might be a corrupted index:

http://www.tek-tips.com/faqs.cfm?spid=700&sfid=1895&CFID=78536181&CFTOKEN=76758074

Linda Adams
Linda Adams/Emory Hackman Official Web site

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com