Expression in Query

G

GR

Hi, I have a query which has a lookup field. The look up
field has 2 Columns. Column 1 refers to a Activity
description, Column 2 refers to a Working Area.

In the lookup field the item that is displayed in screen
is the Activity which is desirable.
But in the query I want to filter by the working area.

First I tried in the Criteria to type:
ActivityID.Column(1) Like "Admin"
Which generates an error message.

Then I tried to create a new field like:
ActArea: ActivityID.Column(1)
Which generates an error message.

Any ideas on how filtering on Working Area without
changing the order of the look up field (I want the
Activity to be displayed in the screen, the working area
is just for my reference)

Thx.
 
Top