I have a quote form that looks up a product we build to get all the pertinent info from such as price and description.
The combo box then takes the ID for the product and saves it to the quote table, the drop down list is based on the products table and only shows active products so someone can't put in a product that is inactive. The problem is this: my older quotes are still in process and I need the inactive product to show if it was put on the quote before the product became inactive. Currently the product id is blank because the item is inactive. I need it to show the inactive product but not let someone use it when adding an item to a quote.
Thanks
The combo box then takes the ID for the product and saves it to the quote table, the drop down list is based on the products table and only shows active products so someone can't put in a product that is inactive. The problem is this: my older quotes are still in process and I need the inactive product to show if it was put on the quote before the product became inactive. Currently the product id is blank because the item is inactive. I need it to show the inactive product but not let someone use it when adding an item to a quote.
Thanks