InfoPath Dev

I have two tables - one for region and the other for site. The common data point is TCS (which is an abbreviation for Region)  What I want to do is have dd B (site) give a limited number of choices based on dd A (region).  dd A selections are the full region name and not the abbreviation. How do I accomplish this?

 

thanks for the help. 

Does the data source for A contain the abbreviation? If so, this can be done, but the filter is a little more complex. When you add the filter to drop down B, you'll add a filter where the region abbreviation is equal to the region abbreviation in the data source for A where the full region name is equal to the region selected in the form. It sounds a lot more awful than it actually is - attach a copy of your form under the options tab in a reply if you'd like a hand. :)

Does this look right for the filter? abbrev (a) is equal to abbrev b and Region (a) is equal to Region (form)

It may be a little more complex than that - in the condition builder for the filter on drop down b, you'd select the abbreviation from B. Then is equal to and in the third dropdown, use a formula. In the formula, you'd pick the abbreviation from data source A and add a filter - in that filter, you'd select the region in data source A is equal to the selected region in the form. Hope that makes sense. :)

So I think I have the filters set up correctly. However, dropdown 2 is not showing a list of values to choose from when I select the field.

The filter is set up and the dropdown shows a set of rows, but they are all blank, no values.

Thankfully, I was able to figure it out. Your solution put me on the right direction. Thanks.