Calculation field that repeats
Right now I have my fields set up like this: "Total Amount", "Payment Amount", "Payment Date", "Balance Due". The "Balance Due" field is the one I have as a calculation. It is set up as Total Amount - Payment Amount .
The "Payment Amount", "Payment Date" and "Balance Due" fields are set up as repeating fields with 2 lines, because more than 1 payment can be applied at different times. For example:
Total Due = $100. Payment Amount = $25 Payment Date = 1/5/2011 Balance Due (caclulation)= $75
How do I apply a second payment to the repeating field so that it calculates the new balance due?