I am trying to create an InfoPath form which reads from a SharePoint list. In particular, the SharePoint list has 2 columns (for now): ToolName, ToolVersion. The InfoPath form has a dropdown corresponding to the ToolName and a text box corresponding to the ToolVersion. I set up the data connection just fine. I can read the ToolName into thedrop down just fine. I set up the rule to populate the text box for Version. However, the text box only displays the version corresponding to the first item in the list. The XPath I have to do this rule is:
xdXDocument:GetDOM("ToolStore")/dfs:myFields/dfs:dataFields/dfs:ToolStore/@ToolVersion
I found in a previous article that I needed to add [../ID = current()/ID] to the end of my Xpath (from above). I tried that and it didn't work - I actually get nothing showing up in the text box.
Thanks in advance.
Mike