There are times when clients do not pay the entire balance on an invoice but make monthly payments on it instead. How do I apply multiple payments to one invoice in my form/table?
My tblCharges includes, amoung other fields, InvoiceID and Charges. My tblPmts includes InvoiceID, pmt1, pmt2, pmt3, date1, date2, date3 but this seems cumbersum and, on occasion, there may be more payment/date fields needed than just the three. My frmBookkeeping has all of the above displayed and is doable but am wondering if there is a better, more streamlined way of accomplishing this.