Assuming you have a relationship between Inventory and Orders (Inventory->Orders) -- my suggestion would be to make a summary field between orders and Inventory, summing the quantity ordered field from orders to your inventory table.
https://help.quickbase.com/user-assistance/create_summary_field.htmlThat way, for each item you'll have an auto-calculating number that shows how much of each item has been ordered. I would then suggest to create a field in your inventory table (or leverage your existing field) to be called "Starting Inventory". Then you could just make a simple numeric formula in Inventory called "On Hand" which would be [starting inventory] - [total quantity ordered].
------------------------------
Charlie Murawski
------------------------------
