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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s