Duplicate Entries???

[Binksy]

I am getting the following error:

The changes you requested to the table were not sucessful because they would create duplicate values in the index, primary key or relationship.

I think I have isolated the error to two tables that I have for a combobox, so that the user has a list of options, eg. Marital Status:

Married
Single
Cohabiting
etc.

What am i doing wrong???

 

[Telsa]

Look in the field in the table that your combo box is changing. Are you using a different table for your combo box to populate the underlying table?

I use two tables.. .one is a lookup table (for my combo box) and the other is the data table (what my selection will populate).

I suspect you are using your lookup table as your data table. Check the properties of your combo box where the field is table/query and compare to the data table you are using to for your form. They should be different.

HTH

Mary )

 

[Garridon]

I encountered this problem myself. It turned out to be a corrupted index field. It also popped up with a message telling me that I couldn't go to the specified record. Try creating a new blank database and import everything into it to see if that clears the problem.


Linda Adams
Garridon@aol.com
Linda Adams online

http://www.geocities.com/hallona_2000

David Hedison Online

http://www.david-hedison.com