>>Hi,
>>
>>I have a wierd problem and I can't figure out what's happening. I have a table with a primary key called 'table_id'. When I manually open the table or when I issue a COUNT() command, I have a record count of 702 records. If I scroll down the table, there are exactely 12 records that are duplicates (meaning they have the same primary key value). That's the first wierd thing but wait, here comes the good part: If I use a scan...endscan statement and increment a variable inside that loop to count the number of records I get... 690 records! Which is the number of records I would be getting if I didn't have any duplicates.
>>
>>How can this be and why didn't FoxPro pick up the duplicates when the data was entered?
>>
>>Thanks a lot in advance, Stephane.
>
>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.

Stephane.