S
scs
I have a customer table and a membership table. A customer can have many
memberships. Most memberships expire after 10 weeks or so. Is there a way
to have an Active checkbox in the customer table uncheck or become false
when all the customers memberships have gone past their expiration date?
The reason I want to do this is because I enter visits on a form into the
visit table. I get the info from a sign in sheet. If I'm entering visits
and a customer doesn't have an active membership I need to know about it so
I can speak with them about renewing. My logic is: Only Active customers
will be available in the pull down list for customers on the visit input
form.
Thanks for any answers or advice.
Steve
memberships. Most memberships expire after 10 weeks or so. Is there a way
to have an Active checkbox in the customer table uncheck or become false
when all the customers memberships have gone past their expiration date?
The reason I want to do this is because I enter visits on a form into the
visit table. I get the info from a sign in sheet. If I'm entering visits
and a customer doesn't have an active membership I need to know about it so
I can speak with them about renewing. My logic is: Only Active customers
will be available in the pull down list for customers on the visit input
form.
Thanks for any answers or advice.
Steve