Hi Mike,
SEEK() and LOCATE are equally fast because of Rushomore.
>Index your table on flag and use SEEK().
>
>>hi all,
>>
>>i have table with more than 10,000 records, at network(many users).
>>
>>i need to found record with flag=0,to get all information at myform
>>
>>i useto locate to finde it as under,maybe somthing else faster.
>>any idea
>>
>>USE newdnc
>>LOCATE FOR flag=0
>>if found()
>> thisform.text4.Value=char2
>> thisform.text7.Value=char3
>> thisform.text6.Value=char4
>> thisform.text8.Value=char5
>> thisform.text5.Value=char6
>>else
>> =MESSAGEBOX("not found")
>>endif
>>
>>thanks.
>>m.qasem