Got it... I read each locate as an OR inclusive, not as individual requirements...
Sorry,
Ric
>It doesn't help because it will include records with any combination of values in the first and second list. For example, the record with fieldname1 = Myvalue1 AND fieldname2 = myvalue4 will be included but shouldn't.
>
>>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