I'm storing a quantity of current items in [tbl_quantity].[quantity]. (key field [ID], related to [tbl_items].[id] via one-to-one with referential integrity)
When using Form FRM_ORDER, I don't want to allow the order to exceed the quantity. (Maybe a message "There are only x quantity on hand, adjust your order now."
What's the easiest way to do this, or does someone have a very simple inventory system (office supplies, not sales) they would like to share?