InfoPath Form – choose “State” only see applicable “Cities” based on that choice

VERY tedious to set this up, but no custom coding.  I’m sure there is a better way to do this, but after beating my head against the wall long enough, this is what I came up with for when you want a choice column for “States” to then only choice applicable “Cities” to choose from.

  1. Custom InfoPath Form
  2. Create Choice field called “State” and manually enter the choices.  This will be the source field.
  3. Create a choice field for each “City” and manually enter the choices.  So there would be a column for “Alabama Cities”, a column for “Colorado Cities”, a column for “Kansas Cities”, etc, etc.
  4. Create a  sections on the form for each City field.
  5. Add rules to hide the City field if the source field does not equal the state.  So, “Alabama Cities” section would be hidden unless “State” = “Alabama”, etc.

Really a lot of work, but easy.

Advertisements