>>
>>Does your primary key have a filter on deleted records? Then maybe your table is somehow corrupted so the deleted flag is not showing or lost? How many records do you get if you SELECT * FROM MYTABLE INTO CURSOR crsTEMP NOFILTER?
>
>My first guess was also that it had something to do with deleted records. To answer your question, I get 702 records with the query.

Then I would say your indexes are corrupt. You might try by dropping your primary key and DELETE TAG ALL. Then see how many records you have. Are the 12 duplicated PKs also duplicated data?