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