Populate Form selections from database

[Nebooaw]

Hi, can anyone help me/point me in the right direction..

I want to run a query against a database, and populate form values dynamically. If i select an item out of any of the lists, the values on the rest of the form will automatically adjust to what is selected? Hope this makes scence?

kindest regards.

 

[Sheco]

Do you mean an HYML form?

 

[Nebooaw]

Im not sure, i want the value i select to act as a filter like a where claus in an sql statement but without running the sql query again. Dont know if its possible to do this but im thinking that when the query is first run, all the values are kept in multiple arrays or somthing, when an item is selected, the form refreshes by filtering the array with the selected value. Hope this makes sence?

kindest thanks.