AnsweredAssumed Answered

Subtract number of select by attribute records from separate table?

Question asked by vonmoosa on Oct 30, 2018

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.

 

 

...Update

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.

 

Outcomes