>Hi Roderick.
>
>>Variable VEHICLETYPE is not found.
>>Error #: 12
>>Program: Search
>>Line #: 35
>>Source: LOCATE FOR &tcSearchString
>
>I'm guessing the wrong work area is selected. Since you chose a field from a child table, you'd need to SELECT that table for LOCATE to work correctly.
>
>If you want to know which table the filter expression is for, check the aQuery array property of the SFQuery object. There's one row in that array per filter condition, and column 3 of each row is the aliased field name. You could then use code like the following:
lcField = oQuery.aQuery[1, 3]
>lcAlias = juststem(lcField)
>select (lcAlias)
Doug
Thanks Doug, I'll give it a try.
Roderick