there is javascript on the details page that executes on the on change event of the select list.
this passes the info to the Products_Detail_Lookup.php page that looks up the new product and returns it back into the javascript tpo update the details displayed on the page.