I have set up my own invoice table and am looking for a way to handle Payments. I have set up a Payments table with invoices linked,  and have all the necessary feilds required to satify my needs , however I don“t know how to carry forward an outstanding dollar amount.     Field 1. Total= invoice Amount        Field 2.=Payments Made   Field 3.=Outstanding Balance .. It”s the “Payments” feild that will increase with every additional payment and the “Out Standing Balance” Field that will decrease.

I think I have been starring at it for too long and now I have no idea if I am going down the right path...... My customers usually pay a deposit and then make progress payments so I need to be able to carry forward a total and show the running payments on a summary receipt.  I have looked at the invoice template but it seems to be more concerned with the actual invoice aspect not so much with the payment part. I guess my goal is to (a) Create a payment (b) Choose invoice by customer link (c) Have invoice amount show with any amounts paid (d) Enter payment details, amount, date type of payment ect.  (e) Have all payments show on a table to “View Print” on a receipt.  I have no idea if this shoud be a Parent to Child situation or seperate tables with just a link.  Any suggestions would be helpful I am at the end of my search ability. 

Thank you..