Here is my problem:

I own a martial arts school and I am trying to create a database in which i ll be able to keep track of my enrolled students and their monthly payment status.

Up to this point I ve created 3 forms, a registration form, a payment type form (different types of payment, monthly tuition fee, private class, school accessories etc) and a final invoice form which takes the name of the student from a dropdown lookup function linked to the registration form, a date, and a payment type dropdown lookup from the payment types form.

What i need to do is, when a student has overdue payments i need a field to show his status as "inactive" andwhen my student pays for his monthly fees, I want his student record to update that field from "inactive" to "active".

To make things even more clear I have two views of the registration form : 1 is the Students view, and another one for each individual student, Personal info or so

Thank you in advance.