I am trying to make sure quantities assigned don’t exceed the current inventory.
Have 2 tables:
Donations List (Parent)
Donations Assignments (Child)
The Qty Given and Current Qty columns (image) are virtual columns in the Donations List table. The actual data entry for assignments is happening in the Donations Assignments table.
I tried using the data validity to set the [Current Qty] >-1 but this doesn’t work. I’m guessing because the form being completed is using a different table. So I’m not sure what expression to use in the assignments table that will do the math to see if there is sufficient quantity available in the parent table - donations list.