Showing current balance in a payment record
I have a payment table connected to a statement table (via statement ID) which is connected to an invoicing table via Invoice Id.
I have a portal based on payments on the invoicing layout in which I post payments and interest. I want to see a current balance on for each record but all I get is a new balance based on the current record. My balance field is a calculation: Principal - sum(amount paid) + sum(interest).
Is there any way I can get this to work?
FMP 10 Advanced Mac 10.6.2