------------->>> your message
Hi,all
I want to find the three record in one table.If they are found,the message
box is appeared that it is successfully.
e.g.
Select table
Locate for fieldname1 = Myvalue1 and fieldname2 = Myvalue2
Locate for fieldname1 = Myvalue3 and fieldname2 = Myvalue4
Locate for fiedlname1 = Myvalue5 and fieldname2 = Myvalue6
If found()
= Messagebox("It is successfuly!",0,"Found")
endif
??? Please tell me!!
Thank you
-------------->>> My soultion
** Try using this code:
select table
locate for inlist(fielname1,myvalue1,myvalue3,myvalue5) and ;
inlist(fielname2,myvalue2,myvalue4,myvalue6)
if found()
= Messagebox("It is successfuly!",0,"Found")
endif
Hope this could be help