https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/105798.aspxMon, 14 Mar 2016 19:34:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105798Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/105798.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=105798So - 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.https://www.infopathdev.com:443/forums/thread/105790.aspxSat, 12 Mar 2016 11:51:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105790semolina0https://www.infopathdev.com:443/forums/thread/105790.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=105790<p>&nbsp;Hi,<br /><br />I am working on Infopath 2010 and do not have access to Sharepoint Designer or the capability to use any code.<br /><br />I am working off the following list which contains the names of Part Managers and the parts<br />they are responsible for:<br /><br />Part_Manager&nbsp; Part1 Part2 Part3 Part4 Part5.....Part100<br />John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y<br />Mike&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp; ..... Y<br />Liam&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N&nbsp;&nbsp;&nbsp; .....&nbsp; N<br />......<br /><br />I have created a dropdown list which shows the name of all of the parts in the system,&nbsp; which for this example would show the partnames of Part1, Part2, Part3, Part4, Part5......Part80 as items in the dropdown.<br /><br />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.<br /><br />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.<br /><br />How can I create such a dynamic functionality?&nbsp; 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?<br /><br />Again, I am working on Infopath 2010 and do not have access to Sharepoint Designer or the capability to use any code.</p><p>&nbsp;</p><p>Thank you.... <br /></p>