Assistance Applying Payments to Invoices

[buddyleee5]

I have a query that is for customer invoices that has an invoice total column and the query auto numbers the invoice. I have a separate table for customer payments that includes the date and amount- what I want to add to the payment form is the application to an outstanding invoice. The customer for each payment and invoice is selected based off of a drop down at the top of the form which looks up the client list from a customer table- preferably I would like the selection of that client at the top to display the invoices for that client and then allow the selection of those invoices for the payment. I know how to add a subreport onto the form that shows invoices, but I can't figure out how to apply payments to specific invoices and once they are applied how they will not be shown in the open invoices report.

Any help is appreciated.

 

[jzwp22]

Can a single payment be split over multiple invoices each with a different amount assigned (i.e. a $500 payment was applied over 5 invoices each receiving $100)? Can an invoice have many payments (i.e. a $1000 invoice has 5 payments of $200 each)?