Problem:
In a table with a compound 'candidate' index my code checks the contents for an existing match to the compund key, using a seek().
If no record is found, then it inserts a new record.
Much to my surprise I have found up to 20% of all records are duplicated records.

Any suggestions on avoiding this problem?
Thanks in advance,
Art Castro