Need Form To Move Records From One Table To Another in the same DB

[Imloyd76]

Ok...I'm new to this forum so here is my dilema. I've created a Database to keep track of inventory in my warehouse. I need to create a form that will in newbie terms "Cut" a record from one table, "Paste" it into another table as well as add information to the record at the same time. So for example: I have a ProcessedMaterial table. My records look like this: BOXID, GrossWt, TareWt, NetWt, Location, Date Processed, Machine, Customer, Operator, Notes. When I ship this item I need to move it to a ShippedItem table as well as add fields for: Shipping Date and Shipped To.

Can anyone out there please give me some direction. I'm lost.

Thank you

[Robeen]

Why do you want to have duplicated data in your database?
Could you not just add a couple of fields [ShippingDate, ShippedTo] to the current Table?
One of the basic things you want to aim for in your database is NOT to have duplicated [redundant] data.

If you absolutely MUST have your data duplicated into another table in your database, it can be done - but I don't think it is necessary.

[Robeen]

I just re-read your post. You want your records OUT of the first table and pasted into the second . . .
Sorry.

Still . . . I don't think you need to go through the trouble.
The fact that there will be a value in ShippedDate and ShippedTo - should be enough for whatever you may need.

[Imloyd76]

Why do you want to have duplicated data in your database?
Could you not just add a couple of fields [ShippingDate, ShippedTo] to the current Table?
One of the basic things you want to aim for in your database is NOT to have duplicated [redundant] data.

If you absolutely MUST have your data duplicated into another table in your database, it can be done - but I don't think it is necessary.

I think that maybe I am miss understood. I do not want to duplicate the data. I want it removed from one table and put into another while at the same time adding information to the record for "shipped date" and "Shipped to". I hope that helps relieve some of the confusion.

[Imloyd76]

Ok....if that would be easier to just add those fields...I think my focus would switch to need a way to create a form to pull the current information from the record and then "Update" the record with the added information. Also I'd have to figure out a report or query that would only pull the items I have in stock or only pull the items that have been shipped.

[Imloyd76]

As an added note....it would also have to remove the data from the Location field if it has been shipped. So if for example I ship a box from row 5, when it's marked as shipped it would remove the information in that location field.