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
>
>
[...]