>>>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.
--sb--