Duplicate value error message when no dupes

[Wrathchild]

Hi, I keep getting the message:

"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 and try again."

when trying to save data to a table. I had this working in an older version and this same problem happened before and I was able to fix it (don't exactly remember what I did). Even if there are no records in the table I get the message when trying to add one. I've repaired the database, deleted the table and rebuilt it, imported all the tables and forms into a new database and made a new table within it...etc. Nothing is fixing this problem now. I even copied the table from the older version that works and it doesn't work still. Anyone else ever run into this? And YES, I've checked the fields in the table for index settings.

 

[Maquis]

Could there be duplicate values in the new data that you are trying to insert? How many new rows are you adding? If more than one then go through the new data and check each id field for dups. Maq B-)
<insert witty signature here>

 

[Wrathchild]

no, there are no dupes in the new record...I'm just saving 1 row. this thing is pissing me off so bad it's not even funny! :-> like I said it's happened before then stopped now it's back...what the f*&^!