Hello,
I have got a problem and I have been trying all my basic skills to solve, but I have failed…
I am planning to make a basic shipment database where a product with an unique inventory ID will be transferee between different storages.
What I have done to date:
Created a table Hardware, where each tool is described with specific properties.
The table Hardware is related to the table Inventory were I am planning to keep track of my inventory.
An inventory entry will be related to a project. So I can have tool 5a for project 1 and 5a for project 2.
Tools (quantities) will be allocated to certain storages. [Capture1]
At some point I will have to transfer tools between storages. I have created the manifest table. In the example below tools have to reach storage 3, but on the way to storage 3 they will have to “stop” in storage 2 (manifest ID 2). Then I will transfer tools from storage 2 to reach the final destination storage 3. [Capture2]
I have then created the table manifested items, where I list in detail what tools will be moved between storages in each manifest. I am using a new table “qty_moved” to create number. [Capture3]
My problem is how can I update the table “inventory” after each manifest is “released”. I have made an example table in excel where stock is changing after each manifest is released. 1st table is the initial state.
2nd table is when stock has been moved from stock 1 to stock 2 (manifest ID 3).
3rd table is when stock has been moved from stock 2 to 3 (manifest ID 4). [Capture4]
Now is my question. How could I in access transfer change/stock. A macro? If yes what kind of a macro?
An expression, if yes, what expression?
Or maybe my table setup is incorrect. Please help
Flooyd
Bookmarks