Are you using Spry? If its not xml you can use
dsFiles.setDataFromDoc(Spry.Utils.stringToXMLDoc(xmlstr)); to make
a dataset from a string created from your db. I have a site with
two pages that use two drop downs- the first gives the options to
the second which filters the data.Enter data if you want its all
test input.
The source code shows how to do it. Check the tran_types.xml
file to see how i change the xpath for each menu selection.
http://www.gohbcc.com/balances/index.php