if (dropdownlist.text = "") {error message} else if (dropdownlistbox.text = "franklin"){search database for franklin then locate franklin unique identifier insert that unique identifier into table2 fk clientid and insert the rest of the information from the web form input field into table2}if (dropdownlistbox.text = "poston"){search database for poston then locate poston unique identifierinsert that unique identifier into table2 fk clientid and insert the rest of the information from the web form input field into table2}if (dropdownlistbox.text = "sara"){search database for sara then locate sara unique identifierinsert that unique identifier into table2 fk clientid and insert the rest of the information from the web form input field into table2}if( dropdownlist.text = "any text in the dropdownlist"){search database for dropdownlistbox.text then locate dropdownlistbox.text unique identifierinsert that unique identifier into table2 fk clientid and insert the rest of the information from the web form input field into table2}