Keeping track of sessions per client
I‘m fresh back to data base construction after quite a number of years and the memory is weak.
What i am looking to achieve is:
A client purchases a number of sessions with me (a Personal Trainer). I need a way to enter the total numbert of sessions purchased and each time I enter a session record that pulls in the client record it can look up the sessions booked, deduct 1 from the total and then record that in the session record and also store it in the client record for use the next time the client record is pulled into a sessions record.
Any help will be greatly appreciated.