I have a primary table called JOBS and a secondary table called PRODUCTS. The JOBS table has a field called "ProductID" which is related to the "ID" field in the PRODUCTS table. The PRODUCTS table also has a field labeled "Product" which is the actual product name. I'd like to build an ASP form for updating the JOBS table and have the form display the data in the "Product" field of the PRODUCTS table (actual name of the product) but update the "ProductID" field in the JOBS table. How do I do this?
