Auto Populate based on term

[avenger619]

Hi Guys,

I was wondering how can I auto populate fields based on a payment term & amount?

example: client has 9 monthly payment of $150 term due every 15th of the month. (I would like it to be able to max out at 30 months)

So what I want to do is populate 9 monthly fields with dates and $150 payments fields next to it. Now, the payment fields even after auto populate, must be flexible in the sense for me to add a different amount just in case client makes an over payment that month too. In, addition I would like a check mark box to auto populate along if possible based on the 9 month term, this way I can manually check TRUE when payment is received in office.

Can this be done?

Thank you

 

[avenger619]

So I found a db sample that is some what useful.
I have played with it and customized it to kind of what am after. If you click view schedule it brings up a form very close to what am shooting for, all that is missing is a functional check box next to each payment row so I can mark true when payment is received in office that month.

In addition for reason to check marks is to also be able to run a "false" report and pull up all clients by date that have not paid.

 

[avenger619]

I cannot find a way to do this, can anyone help? Much appreciated thanks.

 

[avenger619]

Any suggestions welcome.

I have hit a wall:banghead:.

Thank you