I have 3 tables. 1 Master and 2 detail tables both with a different amount of rows. I want the total of the qty in detail1 and the total of the qty in detail2 but show them on the same detail line e.g.
(What I Expect)
Total Detail1: 13 Total Detail2: 45
What happens is, it multiplies the total of detail1 by the number of rows in detail2 and vice versa e.g.
Total Detail1: 65 Total Detail2: 135
65 = number of rows in detail2 (5) x 13
135 = number of rows in detail1 (3) x 45
Is it possible to separate the totalling of these 2 totals?
I am using Running Totals to achieve this currently.