Dependant Queries for List/Menus in a Form

[MinalMoe]

I'm using SQL databases to populate List/Menus in a form.

What I need some advice on is as follows.

The user selects an entry from the first List/Menu that is filled from a an SQL database, which will then narrow the selection for the next List/Menu that is filled from a another SQL database.

How do I make the query to fill the second List/Menu automatically follow the outcome of the first List/Menu, and so on?

Any advice would be much appreciated.

 

[FALCONSEYE]

check Sarky78's post:

http://www.tek-tips.com/faqs.cfm?fid=6607

you can also use AJAX to do the similar thing.

hope it helps..

http://www.jetansolutions.com