Help

Simple Inventory

Topic Labels: Base design
1331 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Joseph_James
4 - Data Explorer
4 - Data Explorer

I am trying to set up my inventory to track shirts given to my employees. I can’t get the look up and/or roll up feature to work. Here’s what Im looking for…

TYPE OF SHIRT | SIZE | QTY ORDERED | QTY ASSIGNED TO EMPLOYEE | CURRENT INVENTORY

If I could get here I’d be set. I don’t know why i can’t get the look up feature to work or the rollup but please help!

1 Reply 1

Hi @Joseph_James - I would do something like this:

Screenshot 2020-06-02 at 08.50.16

“Assigned to Employee” is a link field to the second table:

Screenshot 2020-06-02 at 08.50.22

You can then use a “count” type field to count the number of shirts assigned, then take this from the original quantity ordered to get the the current inventory.


If this answers your question, please consider marking this as the "solution". If not, please post again for more help. Thanks!