Hi All,

Delphi 7.0, FB 1.5

I have two IBO_Queries. One gets the items sold to a customer for a
date range and the other gets the total of these sales amounts for
the same range.

I get the user input for the customer number, begin and end dates
with and IB_Edit and two IB_DateTimePickers with their ParamName set.

The SQL is like this

ITEMS LIST TABLE
Select.... from Table where Custnum = :Custnum and Date_Invoice
between :Begin and :End

ITEMS TOTAL TABLE
Select Sum(TOTAL) from Table where Custnum = :Custnum and
Date_Invoice between :Begin and :End

I have the edit and datetimepickers feeding one table with no
problem, but I would like it to supply the parameters to BOTH tables.

I thought I could do this with the MasterParamLinks in the TOTAL
table, but it will only relate a field in the LIST table to a param
in the TOTAL table.

Is there some way to feed these same params into two tables at once?

Rick