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:


2. List of service requests:


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


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