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