I'm in one of those situations where I've got something working OK, but I have that "there must be a better way" feeling.
Quick summary: I'm building a new website for a college. Our admissions department has six counselors, each of whom is responsible for a region of the country (Northeast, Midwest, etc.). Each region, of course, contains several states. I'm building a "Who is my admissions counselor?" page where prospective students can select their state and it shows them the info on the counselor responsible for that state.
The way I'm doing this now: I added a node for each counselor, then created a "states" taxonomy with all 50 states in it, and assigned the states to each counselor via a multi-select CCK field. This ignores the "region" entirely, but for end users that's OK - they don't know or care how we define regions anyway. Then I'm using an exposed filter in Views (Taxonomy: Term ID (with depth)) to create the drop-down for students to select their state and see who their counselor is. This works fine as far as the front end goes.
Read »
