Merge data from two tables on a form
In a project management app, I have two tables to capture expense records. Expense A contains accounts payable bills, entered manually. Expense B contains credit card transactions. They must be separ...
Forum Discussion
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.
------------------------------
Ryan Buschmeyer
------------------------------