Gathering User Input and Update Choices with Database

[JazzBass]

Hi,
I'm writing a intranet app that requires the user to choose what they want see. Say for example they need to choose the type of fuel they want to see.

Choices: Gas, Diesel, Both

Now, what I want to do is present them with a list box that lists the different types of Gas, Diesel or both depending what they choose before.

To get the types, I need to query the database. How can I do this without having a lot of asp forms. Is there a way I can reload a page with the new values and create controls like listboxes, Radio buttons dynamically?

The above example is one of about 3 times that I need to get info from the user. That's why it would need 3 or so pages.

If you need me to try and clarify, please let me know.

Thanks for the help

JazzBass

[Edited by JazzBass on 01-09-2001 at 11:01 AM]

maybe you can find out on;

http://developer.irt.org/script/237.htm

where you find how you can change the contents of one drop-down-box depending on the choice made in another one using javascript.


I hope I understood well what you meant.
good luck!

[JazzBass]

ines,

Thanks. That's close, but what I need to do is query the database using the value from the first list box and add the recordset contents to the next List box.

Better?
JazzBass