Hi,
I was hoping to be able to get some help on this. Been reading the forums for past couple weeks and finally decided to ask for help here.

We are making forms that require loading database queries without page submission. Also each field needs to pass the data to the next one for loading the queries based on the previous field values.

So lets say we have 3 drop-downs in a form . The first one calls a list through a query and returns an ID on selection. This is simple.

But now on the second drop down we want the result to be loaded from another column of the same row and the same table with the ID that was returned from the first drop down selection.

the third drop down is similar, but needs to load the data from another table.

I really appreciate any thoughts on this.
Thanks,