I am looking for some quidance on setting up a script. I want to setup a script that has a sequencial series that is assigned for each client that tally's for each new record for that client, ie.. new client the series starts back to zero. This will reset back to zero at the start of each new day.
Bob - (each new record has a new session)... 0,1,2,3,etc... the next day it starts over to 0 -> has to be able to go back an forth and keep the series accurate.
So, If I create a new record for Bob and then to Jane and then Mike and throughout the day these keep acquiring new records the series reflects the individuals (number of times or sessions they had in that day)
Same for each client. Right now I am faced with a series that just continues dispite the change of clients.
Just set up a self join relationalship that uses their client ID and the date and counts their records each day.