Just forgot to say:
[...]
Does increment_client_code relate to users or some other table, say clients?
nope.. there is no link between them
If the users.code is empty/null, then the trigger has to get the last number from client_code_increment and put on the users.code column
[...]
