I have a table for maintenance which the user selects the inventory code for inventory used during maintenance. Since the same inventory code could be used multiple times I would like to return the number of records for each inventory code and subtract that amount from a separate table which contains our current inventory. I've been working with model builder in ArcMap but can't seem to find a solution.
I found a tool called Summary Statistics which will give me a count of each inventory type. I will use this data table and join to my current inventory table and use field calculator to subtract these values from my current inventory.