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!