Balance

[TrainingDay]

Hi,

I created a db called tuition

The fields in tuiton are: Students Name, Beginning Balance, Payment amount, date of payment, next payment due, amount of next payment.

When I click on tuition db from mainmenu, and go to student name choose the student I want, and once chosen Beginning balance automatically enters the balance(previous month balance-payment amount) into the field.

Is this possible?

Sorry if this is not clear trying my best!

Thanks

[Wim Decorte]

If you use a script to do this, you can set the field 'Beginning balance' to any calculation you want.

You probably should use more than one table though:

- students

- dues

- payments