Update a ‘yes/no’ field in a table from a form.
when field is marked ‘yes’, the row is not visible in the form drop-down selection.
ProductA, ProductB, ProductC, productD. ‘yes/no’ = out of stock.
On a form, ability to mark ProductD ‘yes’ to where it is out of stock and it will not show on a drop-down menu to select a product.