Newbie report grouping and table linking

jknauft

I've created a report based on the Purch. Inv. Line table. It is grouping by Parent Job No.(added field), Type, and Type No. I'm reporting on the amount field. Everything groups and totals correctly.

I'm now trying to add a field from a second table where the Comm. Job No. should link to the Parent Job No. from the first table, the Type should link to the Type, etc. In the second table I want to print the budget amount that relates to the combination of the Parent Job No., Type and Type No. from the first table. Both tables are multiline meaning each combination of Parent (Comm.) Job No, Type and Type No. from both tables have multiple amount lines that are added together.

I've tried using the CREATETOTALS function but it only shows a zero amount.

Thanks,
Jon

jknauft

I'm now able to show the Budget amount but it's showing the total budget for the Parent Job No. It looks like this:

Parent Job No. Type Type No. Budget Amount
J1 B 1000 50000
J1 B 1500 50000
J1 C 2000 50000
J1 C 2500 50000

Any ideas?

Jon