AnsweredAssumed Answered

Keeping track of sessions per client

Question asked by andy@the-wod.co.uk on Jan 15, 2012
Latest reply on Jan 17, 2012 by philmodjunk

Title

Keeping track of sessions per client

Post

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.

Thanks

Andy

Outcomes