Auto populating a pulldown list

[Olivia_Crazy_Horse]

My form will have two dropdown/pulldowns. The first contains ten states and the second contains fifty cities, five for each of the ten states. If no selections are made, then all the states and cities are returned.

If the state of New York is selected, then I need the cities pulldown list to be auto populated with the five cities that are in New York. If the state of California is selected, then the cities pulldown list should be automatically populated with the five cities in California, etc.

How do I automatically change the cities pulldown based on the state pulldown ?

[Dan_Bracuk]

I do it like this: http://www.pathcom.com/~bracuk/code/RelatedSelects.htm

There is also a custom tag out there somewhere. Google "coldfusion related selects" You'll find lots of choices.