Forum Discussion

ArbabRizvi's avatar
ArbabRizvi
Qrew Member
6 years ago

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

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...
Relationships
AdamKeever1's avatar
AdamKeever1
Qrew Commander
6 years ago
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
------------------------------
ArbabRizvi's avatar
ArbabRizvi
Qrew Member
6 years ago
I don't think you understand.

Here is a screen shot to better explain:

Here is my Inventory Table:

As you can see, the stores table has many different equipment.

I want to take the sum of each piece of equipment across all stores and provide them on the equipment table and it should look like this:

Equipment 1 - 50
Equipment 2 - 10  

etc.


------------------------------
Arbab Rizvi
------------------------------