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.

Sounds like you've made a lot of extra work for yourself. The supervisor's and all the employee's work should be in a single table. That table should have an "assigned to" column. You can use a parameter query to select only rows assigned to a particular employee. The forms/reports would then be based on the parameter query.

Your method requires a new table to be created for each new employee. Isn't that a little like installing a new file cabinent when you hire a new filing clerk.

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