And still one more...

  SELECT * from mytable;
   WHERE (INLIST(fieldname1, Myvalue1, Myvalue3, MyValue5) ;
         AND INLIST(fieldname2, myvalue2, myvalue4, myvalue5));
   INTO CURSOR mylocat
   If _TALLY = 3
     =Messagebox("It is successfuly!",0,"Found")
   endif

>
>>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