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