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.
- Custom InfoPath Form
- Create Choice field called “State” and manually enter the choices. This will be the source field.
- 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.
- Create a sections on the form for each City field.
- 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.