InfoPath Dev

 Hi,

I am working on Infopath 2010 and do not have access to Sharepoint Designer or the capability to use any code.

I am working off the following list which contains the names of Part Managers and the parts
they are responsible for:

Part_Manager  Part1 Part2 Part3 Part4 Part5.....Part100
John                  Y        N      N       Y       N          Y
Mike                 N        Y      N       N       Y    ..... Y
Liam                 N        Y      Y       Y       N    .....  N
......

I have created a dropdown list which shows the name of all of the parts in the system,  which for this example would show the partnames of Part1, Part2, Part3, Part4, Part5......Part80 as items in the dropdown.

Upon selecting one of the parts in the dropdown box above, I would like to populate another drop down box with the names of the Part Managers that are responsible for that one part.

So if Part4 is selected from the first drop down, the names John and Liam should appears as individual items in the second drop down.

How can I create such a dynamic functionality?  I am able to do it for one part by using a Filter and saying dropdown1_value=Part1, but how can I generalize this to apply to all the parts?

Again, I am working on Infopath 2010 and do not have access to Sharepoint Designer or the capability to use any code.

 

Thank you....

So - each part number is its own column? I started out trying to describe adding a filter, but then realized that each part number was its own column. Where do your options for the Part Name drop down come from? Are they the exact same names as the columns? Any chance I can see a copy of your form - you can attach it to a reply under the Options tab.