Trying To Create Inventory Tracking Table

Occasional Contributor

I need to get some help on creating a inventory tracking table. Here are the components I have:

1. Original list of inventory in:

lordbyronxxiv_0-1650309184224.png

2. List of service requests:

lordbyronxxiv_1-1650309412892.png

Using the data from these 2 tables I need to produce an inventory table that shows the current inventory, similar to the following:

lordbyronxxiv_2-1650309585032.png

One problem is that for certain equipment there will be a line item for each piece of equipment, a laptop per say, but for others like keyboards and mice it might have 1 entry with a quantity of 50.

 

Any help is appreciated.

0 Replies