duplicate entry on key 1

Help! I have a problem with a database which gives a "duplicate entry on key 1" error message when I try to re-add a record that I have just deleted. I have a feeling it has to do with my index.. my key column is shown like this in the create statement: Create table 'mydb' ( 'MyKeyField' v

duplicate entry on key 1

Help! I have a newbie question. I have a problem with a database which gives a "duplicate entry on key 1" error message when I do a select on a record that I have just deleted. my key column is shown like this in the create statement: Create table 'mydb' ( 'MyKeyField' varchar(30) def