I began a conversation on FileMaker's community forum regarding the various methods for updating quantity fields in an inventory database (e.g. on hand, allocated, available, on order, etc.). This demo file shows the method I employed at the time - putting a portal on every layout that triggered an update.
This file is open. You are welcome to download and experiment with the different methods.FMP 12 File