Bob, I'm not sure what you mean by "run through the table," However,
a compound condition is perfectly fine for lookups in reports.
The lookup will return a value from the "first" row it finds that matches
the conditions, then will stop looking.
If you are not getting the correct value, here are two things to check:
Be sure there is an ID column in the view or table on which the report is
built. If there is not, or if it has a different name, then your first lookup
will always return the first row it finds in activitysched, because
activitysched.id is always equal to activitysched.id.
Also, be sure the lookup variables are evaluated ("Change Section",
from the Variables menu) in the same section as the section in which
they are located.
Bill
On Thu, 28 Jun 2001 14:12:05 -0400, Bob Powell wrote:
>vVar1 = ACTCOMBINE IN ACTIVITYSCHED WHE ID = ID
>vVar2 = ID IN ACTIVITYSCHED WHE ACTCOMBINE = .vVar1 and
role = 'advisor'
>Am I correct in stating that the vVar2 does not run through
>the ACTIVITYSCHED table to satisfiy the compound clause of
>.vVar1 and role = 'advisor'?
