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