What is the recommended way to structure the relations and rollups in Glide to achieve this?

Hello Glide team, I am building a production management app. In my system, there is a Production Order table, and each order uses a specific material. I want to create a workflow where, when I issue materials for a production order (create a material issue record), the inventory of that material in the Material Inventory table will automatically decrease. My current tables are: Production Orders Material Inventory Material Receipts Material Issues The goal is: when I create a material issue from a production order, the corresponding material quantity in the inventory should automatically be reduced. What is the recommended way to structure the relations and rollups in Glide to achieve this? Thank you for your help.