How can I preserve selections made on a form from a Combo box if an item that was previously selected is deleted from the source lookup table?
i.e. On a purchase order form, a combo box provides for selection of a vendor to be associated with the purchase order ID.
At a later time that Vendor is removed or flagged inactive from the source lookup table but I want to be able to re-open the purchase order form and still see what vendor was selected at the time the purchase order was created. I do not want the deleted/inactivated vendor to show up in the combo box for future purchase orders.