How to Track Inventory (Should be Simple but I'm lost)

Problem: I want to create a "Inventory" table that automatically reduces each equipment quantity as I deploy my equipment at different stores. Current Setup: I have a stores table. The stores table...