Jump to content

This topic is 7237 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7237 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.