Direct Debit

[Jed69]

I am about to start using direct debit for my customers and I am trying to think how I could record this on my database. At the moment there is a Customer table that has a job table related to it that creates a cost figure and I also have a related payment table that records income against each customer. And from these two figures I have a running balance. This works well, but these are only one off payments. Ideally I would want to enter direct debit information once with a day of the month for the payment, number of payments and start date. Then of the day of a relevant debit the database would produce a list of debits to be made that day and debt the amount from the amount owed for the relevant customers. This is all making my brain ache so I wondered if anyone had any advice or if anyone had done something similar already.

[Jed69]

OK since posting this I have found something new. This is maximum number of repetitions. So I have created a field called DD Start Date and one called DD Number of Transactions. What I would like is in a new field called DD Transaction Dates to have a calculated field with 12 maximum number of transactions, which would calculate the dates which the transactions would take place. EG with a start date of 12/01/08 and 3 for the number of transactions would come out with the result 12/01/08, 12/02/08 and 12/03/08 in DD Transaction Dates field. Can anyone help me with what the calculation should be?