Skip to Content
0
Former Member
Jul 16, 2009 at 04:05 PM

Value from another query

16 Views

Hi,

One of the fields in a query should be populated from another query. But the selection criteria should be sent from the first query result.

Eg.

InObj1      InObj2       InObj3  InObj4          InObj5
1        01/10/2009      2     04/01/2009         ?

InObj5 should be obtained from the second query based on the selection of InObj3 and InObj4. All are characteristics.

How to achieve this?

Thanks.