Invoice Payment Subform
Invoice Payment Subform
Is it possible to use subforms to create a invoice payment form.
I am trying to import invoice details to a form with information about the invoice (e.g. invoice #, invoice amount, invoice due date) and then create a form where the user can enter select an account and view the invoices that need to be paid. They would then enter the payment amount and select the invoices to be marked as paid.
For example
Account: XXXXXXX
Date: 07/20/13
Amount: 100.00
Invoice # Invoice Due Date Invoice Amount Pay
1123 07/31/13 25.00 25.00
1434 07/25/13 100.00 75.00