I'm trying to dynamically change a drop-down select field based on the selection of a previous selection box. In this case it's

Select City

Then based on the city, the county select box does the DB look-up for the counties and populates the County list

Select County

Table: jml_lookup_uscounty
Column for Value: county
Column for Text: county
Sql WHERE parameter (optional): state =


I'm having a hard time getting the value for from the select city field to use in the Sql statement.

Any help would be appreciated.