AnsweredAssumed Answered

Keeping track of sessions per client

Question asked by on Jan 15, 2012
Latest reply on Jan 17, 2012 by philmodjunk


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.