How to handle large select lists in content types? I need to add a city field for a content type in D7. I'm getting it from a federal census table and it's going to be around 35K+ records. Any thoughts on filtering this list down by state and/or county? Without some kind of filtering, I'm afraid I'll bring Drupal to it's knees. BTW, I can't just use a taxonomy list because I need to key the list on a city ID. I also will have county ID info. So, I really need to filter the counties list to just those for the state the user has selected, then the cities by that county.

Here's the general structure:
User selects
   State ->  County-> ->Cities.

I tried looking at the references module but the reference field I created didn't seem to be filterable.

Thanks for any assistance!
Sounds like a perfect job for Simple hierarchical select

Simple hierarchical select defines a new form widget for taxonomy fields to select a term by &quot;browsing&quot; through the vocabularies hierarchy.
The widget is available in node forms and as Views exposed filter.

You can add your locations as a hierarchical taxonomy, and SHS will AJAX-load child terms into a new inline select, then children of those in a new select, and so on. Something like