I know on a basic level how I want to set up this chain of custody. In a nut shell here is the break down....

I receive work package 12345 and I track that I have indeed received it through a form created from a table in access.

I then schedule the work package to be completed by a crew.

I then give this crews boss the work package to distribute to the crew.

The boss gives it to that crews lead.

Lead gives it to the crew.

Crew does the work.

Package comes back to our data entry clerk to be posted for completion.

This happens on a much more massive scale, everyday about a billion times a day...ok maybe not a billion but close.

The tracking of these work packages is at best....lousy.

Here is what I want to do...

After I schedule the work package 12345, I would like to be able to copy just that specific data from my "received" table to the boss' table and have the "boss" be able to move it from his table to the leads table, and so on. I would like to be able to do this using forms and preferably with only the click of a button by each end user. Also it would be a plus if once it was moved from one table to another, it was removed from the previous.

Please help.....



P.S. I work for the cheapest oil company in the world and am running with MS Access 2003.