transferring records from one table to another

[mghdb]

i'm trying to create an application where it will allow a supervisor to assign work to employees by moving the work id into employees work tables, but i cannot have duplicate work id's, for example if a supervisor assign work id 9999 to employee 3, that record will be removed from the supervisor's table and be place into employee 3's table. Is this possible?

Thank you for any help.

 

[chrismcbride]

Have sent a very rough sample of some things that may work for you...
Chris