thanks so much eric really appreciate your help.
so just to clarify, the usersid is stored in a session variable is this at the login screen you would create the session and therefore do not need to add this column in the client table of database?
many thanks again for your great help.