How to Track Inventory (Should be Simple but I'm lost)

Question

Problem: I want to create a "Inventory" table that automatically reduces each equipment quantity as I deploy my equipment at different stores.Current Setup: I have a stores table. The stores table has fields for different equipment that is deployed at that store.ex. Monitor, LaptopEach store may have a different quantity of equipment deployed.ex. [store 1000, monitor Qty 4, Laptop Qty 3], [Store 1001, monitor Qty 2, Laptop  Qty1]Whenever a store has equipment deployed, I  update the quantity to that number.What I tried to do: - created a table called "equipment"- Added Fields [Equipment Name, Equipment Qty on Hand, Equipment Qty Deployed]..now I'm a little confused, do I need to create a "Store" field as well and upload every store number that is on the Stores table and then link them? what is the best way to get the summary of each equipment deployed across all stores, subtract it from my inventory on hand and give me the current quantity available number?------------------------------Arbab------------------------------

AdamKeever1 · Answer

If understand what you are wanting, yes you would want the tables related. There are at least three ways you can do this. You can relate them and then manually add the store to each equipment, you can add a stores field as you stated and then relate them, or you can create a spreadsheet and include a unique ID and then relate them.

Take a look at this post and see if it gives you some guidance:
tables, IDs, and relationships

------------------------------
Adam Keever
------------------------------

Sign up

Login to the community