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.