Michael,

Right. Primary keys cannot be duplicated. So are you getting dupes slipping in despite having specified that the index is primary, or is your key generation routine not working properly and giving you keys that are already in the table?

Exactly how have you specified that the field is a primary key? Exactly how are you generating them? Any filter on your index like "FOR !DELETED()"?


>How can VFP allow primary keys to be duplicated in a table? If I specify a primary key shouldn't VFP never allow it to be duplicated. Your thoughts would be greatly appreciated.