Exactly, I've forgotten the basic of database programming *blush*

thanks a lot!

>Perhaps there is a corrupted index. Try to REINDEX.
>
>>Hello everyone,
>>
>>I have a table with column "ac_no" as the unique primary key, my program works well with the table for a long time.
>>
>>But today I find that I cannot locate an account with ac_no='12345'.. I used
>> set filter to ac_no='12345'
>>but it shows no matching record.. all other records can be located by the set filter command but only this one fail. I can find the record when no filter is set so I'm sure it's not deleted or what.
>>
>>also, since the ac_no is set unique, i should not be able to append a new record with duplicated ac_no, but i can create a new record with ac_no='12345'
>>
>>seems foxpro regarded this '12345' as another '12345'..
>>
>>i wish i have expressed the problem clear enough, do anyone know what is happening with this record? how can I avoid from it?
>>
>>thank you very much,
>>Jimi