New to Filemaker here, creating a database for an art gallery. My goal is to have the "update inventory" button subtract "1" from the amount of stock. Once the sum becomes "0" you can no longer select it in the drop down menu on the invoices page. Been trying to figure this out for days, and now I'm wondering if this is even possible. Can anyone help?