Home Datapipelines

True Master/Detail Parametrized Linking???

edited April 2011 in Datapipelines
Delphi 2010
RB 12.02 (729)

I have a master data set that is manual SQL:

* dsCustomers
o SQL: Select CustomerNbr, FullName from Customer

I have a detail data set that pulls from a stored procedure:

* dsCustomerOrderHistory
o SQL: Select * from SP_REP_CustomerOrderHistory(:CustomerNbr)

My issue is that I need to be able to link the detail query to a field
in the master query without it being in the where statement (it has to
be passed as a stored procedure parameter).

Is there currently any way to reference a field from another datasource
without it going into the where clause?

Branden Johnson
Integrity Software Design
This discussion has been closed.