I am trying to figure out the best way to set up some kind of relationship (Relationship Class?) between multiple features and a limited quantity. The scenario is this: There is a large pile or piles of soil in specific locations with some quantity of soil and soil is planned to be removed from that/those piles of soil to new locations. Is there a way to set up a system where if you take a certain quantity from one pile into another, it will automatically deduct the amount of removed soil from the pile it was removed from? I'm basically envisioning field crew using Collector to remove and add soil from different locations and have it mathematically be in sync in real time using some kind of scripting function (Arcade?) to make it balance the quantities and maintain equilibrium. Hope that makes sense. Thank you.
... View more