Conditional Checking and Field Population

[RhondaR]

I have a situation on my form, that if a certain value is selected in a drop
down list in "field 2" then I would like the values in the drop down list in
"field 19" to be dependant upon what was selected in "field 2".

For example If in Field 2 I select the value " Dallas" then in Field 19
I only want the values "Texas, Georgia, New Mexico, Louisiana" to be
available as options in the drop down list for field 19. If in Field 2 I
select the value "New York" from the drop down list, then in Field 19 I want
to show "New Jersey, New York, Mass, etc" as selectable values in the drop
down list.

How can this be done? The values are "hard coded " in the drop down list on
the form, they are not part of a file that can be read.

Thanks very much for any assistance given.

 

[K.Ramana Reddy(GGK Tech)]

Hi,

You must need to use data Sources for drop downs to work your scenario,
Check out below link,
http://www.infopathdev.com/blogs/gr...a-Cascading-List-from-a-Flat-Data-Source.aspx

I hope this will help for you.

 

[David Dean]

Here's another approach you can use if you have only a small number of
options in field2:
- Select "field19" from the Data Source panel and add another dropdown
listbox to the form. Repeat until you have a separate dropdown control for
each option in "field2".
- Change each field19 dropdown to include only the appropriate values for
one of the field2 selections.
- Add a Conditional Formatting expression to each dropdown control to hide
the control if field2 is not equal to the value that corresponds to the
selection list for that dropdown.

I don't recommend using this approach if you have more than 4 or 5 possible
field2 values. The suggestion made by k.Ramana will work better in that case.