Coordinate Dropdowns

[flhtflht]

Hi,

I have the two queries for use in dropdowns.

SELECT id, descr

FROM districts

ORDER BY descr

SELECT id, district, descr

FROM counties

ORDER BY descr

A district will be selected first, then I would like counties option value to display only rows only where counties.district = districts.id.

Any Ideas?

Thank You in Advance for Your Help!

[Dan_Bracuk]

What you are looking to achieve is frequently called Related Selects.  There are more than one way to approach it.  The one I use is described here http://www.pathcom.com/~bracuk/code/RelatedSelects.htm