I have one primary table and 2 foreign tables that I need to use in a report. The relationship between the primary and foreign table (in both cases) is one to many. For each row in the primary table, I need to show totals from fields in the foreign tables.
Let me try and explain.
Primary Table Foreign Table Foreign Table
CUST DEMAND TERM
The report should look like this:
Cust ID Demand Total Term Total
3 $460.55 $86.00
5 $983.00 $8438.00
16 $907.98 $5471.08 ....
What happens when I link the cust.ID from the primary table to the cust.ID in the Demand table and then the cust.ID from the primary table to the4 cust.ID in the Term table is that I get duplicated products.
I'm trying to stay away from using sub-reports (due to time). Is there another way of avoiding duplicate records?
hh...
Let me try and explain.
Primary Table Foreign Table Foreign Table
CUST DEMAND TERM
The report should look like this:
Cust ID Demand Total Term Total
3 $460.55 $86.00
5 $983.00 $8438.00
16 $907.98 $5471.08 ....
What happens when I link the cust.ID from the primary table to the cust.ID in the Demand table and then the cust.ID from the primary table to the4 cust.ID in the Term table is that I get duplicated products.
I'm trying to stay away from using sub-reports (due to time). Is there another way of avoiding duplicate records?
hh...