I have a query with Microsoft Frontpage because I am trying to learn HTML and ASP.
I have a list box on a web page that gets its values from a table called dbo_PRODUCT and a field called PRODUCTCODE. When I publish the asp page it displays a list of the codes in that field.
What I dont know how to do is this :
The dbo_product table has columns of :
I want to create a text box, so when the user selects a code from the productcode list the text box populates itself with the description.
Also I want to create a text box where the user can enter feedback. I then want them to click a button called Save which will add the record to a table called Comments which has fields of PRODUCTCODE and COMMENTS. So I want to be able to tell the form to add the record and use the PROUCTCODE that was selected in the list.
Can someone please help me through my learning curve ?