oops... line three should read "> AND INLIST(fieldname2, myvalue2, myvalue4, myvalue6));"

Sorry.

>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