I want to be able to change the value of the second select box based on the input in the fist select box.

As an example, if a person selects USA from the first select box they should only be able to choose from 'napa' or 'paso robles' in the second select box. If they click on France in the first select box they should only be allowed to choose from 'Bordeaux' or 'Provance' in the second select box.

Both select boxes are loaded from a mysql database, adding another layer of neck pain to the equation. I think this will require something like jquery and I'm just not any good at that.

I feel there is probably a really easy way to do this, but between my lack of real javascript skills and this being a zend framework form I'm just not sure how to trigger the database pulls to change the options in the second select box without reloading the page.

Help, anybody? Beuller... Bueller...