Skip to main content
Known Participant
March 1, 2010
Question

Coordinate Dropdowns

  • March 1, 2010
  • 1 reply
  • 257 views

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!

    This topic has been closed for replies.

    1 reply

    Inspiring
    March 1, 2010

    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