If you have a tag on flag, locate is as fast as you can get it. However, remember that, depending on different parameters, you may lock the record. To avoid that I usually prefer

SELECT * FROM newdnc WHERE flag=0 into cursor curTemp
if _tally>0
  thisform.text4.Value=curtemp.char2
  thisform.text7.Value=curtemp.char3
  thisform.text6.Value=curtemp.char4
  thisform.text8.Value=curtemp.char5
  thisform.text5.Value=curtemp.char6
else
   =MESSAGEBOX("not found")
endif

>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