>>Maybe only duplicates are the deleted ones and 'set deleted on'. (Uniqueness error would occur). Try :
>>set deleted off
>>SQL...
>>Cetin
>
>Cetin,
>
>That was it exactly. Thank you very much for your help!
>
>Jon

Jon,
Glad you found:) Besides them also check for empty record, it too can cause a uniquness error on an attempt to insert a new record.
Cetin