Keep in mind that I haven't used access in many moons, so cut me some slack. I have a table for people, and a form based on that. I have a table for payments (person, amount, date) and a form based on that. On the PEOPLE form, I have the PAYMENTS form as a subform, with the key fields linked to show only payments for the current person. So far so good. Now I want to create a new, separate form, so that a single "payment" can pay for multiple people. On this form, I want today's date, followed by a variable number of lines, just like an invoice. Each line item should include a combo box to select the person that portion of the payment should apply to, and a payment amount. Then at the end, a total line that summing all the payments and giving a final amount (no tax). The part that's being tricky for me is this: I need each subpayment line to be a new record in the payments table. It seemed at first like this should be easy to do, but now I'm not so sure. Can it be done relatively simply?