>>>>It's a flag in the Employee table, in the UserGrLink table and in Employee_Queue_Profiles table. Also if the employee has accounts in his/her queue, I think, I need to give a warning that accounts have to be transfered first, so that employee could not be terminated yet.
>>>
>>>Shouldn't be other way around?
>>
>>What do you mean here? Terminate first, then transfer accounts or don't have flags in children tables?
>
>If employment is terminated, your program cannot refuse to process it just because there's something in the queues.
The work load of this employee has to be distributed first. I have a form that allows to assign accounts to employees or transfer accounts. So, if I found that the employee has accounts I can fire that form. I can, of course, move the accounts back to unassigned queue behind the scene, but it would be better to give manager a control of what to do with the accounts.
If it's not broken, fix it until it is.
My Blog