Running Total with fields from different tables
Table X (Think of it as Purchase Invoice Table)
Table Y (Think of it as Payment Voucher Table)
No relationship defined yet between Table X and Table Y
Table X Fields:
2. Bill Amount
and some other fields
Table Y Fields:
2. Payment Amount
What I want:
A ledger showing running balance of net payment.
The ledger will be based on Name.
Each portal line will have fields: X::Date, X::Bill Amount, Y::Date, Y::Payment Amount, Net Running Balance