Summary fields in sub summary part

[NewFM85User]

Hi,

I have 2 tables. Orders table and Template table. Orders are created every issue from template table.

But the customers can modify the order for that issue. Both these tables are related by issue ID.

I want to create the the report to campare the total count of actual order of booklets every issue Vs the count of booklets customers are supposed to order.

When I place the summary fields from both the tables in sub summary part on the report, it shows the total for just one table, the other subtotal is the total of last order.

How can I get the subtotals of both the fields?

Please advise.

Thanks for your help.

[comment]

These parts are not clear:

Orders are created every issue from template table.

What does a record in the Template table represent?

Both these tables are related by issue ID.

Is there a table of Issues?

the count of booklets customers are supposed to order.

Which would be where?