Move data from one table to another

[rebyrd]

I'm a beginner @ Access so please forgive my ignorance ahead of time.



I'm trying to develop an inventory management system in Access. The Access template doesn't fit my needs however. Basically, I need to move product from a "Receiving Table" to a "Shipping Table" upon command.

When entering product in to my Receiving table, I have access automatically provide a "case ID #". Each pallet of product in the case will have its own case ID #.

The receiving table is essentially my Stock On Hand Report. I would like to be able to create something that prompts me to enter a "Case ID #". Upon doing so, this would move the material off my On Hand Report, or Receiving Table, and put it in to my "Shipping Table". Once there I will use that table to create a packing slip, etc.

Any suggestions? I don't have enough Access knowledge to know if this is somthing really easy or really hard.... Thanks in advance!

[RuralGuy]

You may find this link helpful.

[MAF4Fam6]

If both your tables are exactly the same with the exception of one being named Shipping and the other Receiving, then another suggestion would be to have only one Table.
Simply add an extra field name to your one table and call it something like txtProductStatus. Then use values like "Shipping" and "Receiving" to run separate queries for different types of reports.

RC,
Fruit Heights, Utah