[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

[tscinc]

You can complete that with the script step set field.

Set field (balance) = Balance - last payment amount

Not the best way to keep track of this sort of thing, but it will work.

You really want to keep a charges database and a payments database and use the Sum function in a calculation to determine the balance due.