Merge data from two tables on a form

David,

My initial thought was just to propose having the sub-reports of Expense A and Expense B shown in the "Job" form...say in separated tabs. In this way you wouldn't have to worry about the clunky pipeline issue.

For totals, you could simply have a summary field for each sub-report of A and B, then create a formula field that totals those two summary fields.

Right now, that's my best suggestion, but I'm not sure that solves your problem.