>IF INLIST("Y",my_field1,my_field2,my_field3.....on to whatever
>
>>I am looking for a shortcut way to do this.
>>Thanks in advance and then some.
>>
>>IF mytable.my_field1 = "Y" OR ;
>> mytable.my_field2 = "Y" OR ;
>> mytable.my_field3 = "Y" OR ;
>> mytable.my_field4 = "Y" OR ;
>> mytable.my_field5 = "Y" OR ;
>> ...(do whatever)
>>ENDIF
John,
Just to be a PIA, here's another one that works;
IF "Y" $ My_field1 + My_field2 + My_field3 + MY-Field4 ...