Hi try this



<select name="strl"><%do until rs1.eof%><option

value="<%=rs1("strlID")%>"><%=rs1("storlek")%></option><%rs1.movenext

loop%></select>





roger



-----Ursprungligt meddelande-----

Från: lodris@m... [mailto:lodris@m...]

Skickat: den 21 maj 2001 20:30

Till: ASP Databases

Ämne: [asp_databases] pulldown lists from database





I was wondering if there is a way to select an option in one pulldown list

(whose contents is populated from the database) and then when that user

selects that option to automatically fill in the rest of the fields that

are related to that row in the table.For example if i choose a product and

the next field is price which is currently blank is there a way depending

on which product i choose to automatically fill the price text box with

data from the database.

Some sample code or suedocode would be great if you could.

Thanks

Leigh