True Master/Detail Parametrized Linking???
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?
--
Regards,
Branden Johnson
Integrity Software Design
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?
--
Regards,
Branden Johnson
Integrity Software Design
This discussion has been closed.