InfoPath Dev

 I figured it out - brain dead on my part. xdXDocument:GetDOM("Business L1 Organization External")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID[../d:Title = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:L1_x002d_Benefits_x002d_1]  The 1, 2, 3 at the end need to be changed to 2 , 3 ...

 This is great! I never would have gotten hat. thank you so much. It is working for the most part and I suspect I will have to make multiple connections to the L1 list at least but thought I would ask. As you say I have  seven L1's, L2's etc.  When I choose an L1 (say CEO) in the first list it filters the second list ...

 

Thanks for the reply and offer to help! I can get the cascading to work but then I get ID numbers in my SP list. Of I can get no cascading and get the text in the text boxes.  I can't get pictures to show but here are links to Dropbox  https://www.dropbox.com/s/53ljiagld2abbti/List-sections.JPG?dl=0 this is ...

 I have a situation that has me stumped. It is probably easy but I am a novice at InfoPath (2013). A form library will not work for this situation due to a number business requirements I am locked into a SP list. (Building the list form an XML file is also not an option) Any help would be appreciated.  NOTE: When I use ...