Hello,

I have an airline route database that I would like to convert to a searchable form. I've seen AJAX database field updates, but I'd like one without a particular starting point.

My form has 6 options right now.

To City, From City, To Airport, From Airport, To Airport Code, From Airport Code

I've heard there is a JQuery plugin that would be able to allow be dynamically change the selections available in each field, when a single field in chosen, as well update dynamically when additions fields are entered after the first update.

I can't seem to figure which plugin this is though.

For example, entering "Florence" as a From City would update all the other fields to show only valid results for "$from_city=Florence"

Since there is only one airport, "Amerigo Vespucci Airport" would be the only option of the "From Airport" and "FLR" the only option from the Airport Code.

There are however many flights originating from Florence to other destinations, so the form would populate the "To City, To Airport, To Airport Code" again with only with database results that match $from_city=Florence"

If then a visitor decide to enter "London" as a To City, then the form must re-populate results only with "$from_city=Florence+$to_city=London"

Since London has "three" airports, this still have three options showing in To Airport (Heathrow, Gatwick, Stanstead) and three matching options for To Airport Codes (LHR, LGW, STN) with only London avaiable a To City.

While I have some code written, I'd rather just start from scratch using a JQuery plugin since it handles AJAX calls rapidly and allows show-as-your type AJAX is easily added.

If someone can point me in the right direction of JQuery plugin(s) that match my need, I would very much appreciate it. Or if you think that this is easily coded, please let me know as I woud be willing to outsource the project too.

Thanks :-)