Just add a recordset to the top of the page that filters by the submitted productID from the dropdown. Then you can use the fields from that recordset when inserting to get the rest of the necessary product information.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.