Bob:
It looks to me like your supposition is wrong. But, I am not sure what you asked. The
lookup will satisfy both conditions placed on it - your presumption of NOT is
incorrect. Presumably there is only one row that satisfies the conditions in each
lookup. If you mean RUN THROUGH to indicate that the lookup makes a list, then you are
correct - it can not do that.
The part that bothers me is that the two lookups appear to be circular.
Hope this helps, and hope the list doesn't tear up my response too badly!
Jim Blackburn
Kodiak
Bob Powell wrote:
>
> Hello everyone:
>
> I have placed a variables in a report defined as
> follows:
>
> 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'?
> ----------------------
> Bob Powell
> The Hotchkiss School
> Lakeville, Connecticut
> Systems Administrator
> [EMAIL PROTECTED]
