Setting up payments, continuous form

[Pyro]

Hi,

I am making a a db that records information about students, courses and payments.

I have a situation where all courses run for 12 months, and most students make graduated payments on the first of the month, for every month of their enrolment. However there are cases where some students make more frequent payments and therefore more payments in total.

Currently i have a continuous form set up, and each payment is entered manually. What i am wondering is whether i can have a "pre-set up" of 12 payments with their due dates, and manually enter their payment amount every month, but still facilitate extra payments beyond the 12 if necessary.

I have thought about having a table with 12 payment fields, and then a second table to record extra payments. Or maybe 12 unbound text boxes in the header of the continuous form that append data in the event that there is data? Both of these methods seem kind of clunky to me.

Another idea that just occured to me would be to have a button that appends 12 sets of due dates to the one underlying table, and updates the continuous form. But i would have no idea how to write the sql to append 12 rows and calculate each due date...

Any input would be extremely appreciated.

 

[wiklendt]

why not have a calculated field in the underlying query of your form which calculates the next due date from the last payment made, and then another to test whether the payment is overdue?