InfoPath Dev

We communicated over a PM, and in the interest of posting a solution for anyone who finds this thread in the future, my problem was that I was trying to change the values of the KPIDescriptionID to the KPI Name whenever that field was equal to the KPIDescriptionID field of my secondary table source. However, when I tried to change the value of ...

 Based on the answers you helped with at the end of last week, I tried doing some additional research this morning.  I found this site: http://blogs.msdn.com/b/timpash/archive/2005/10/26/using-current-function.aspx  in the XML equation above, I changed it from: = current()/@KPIDescriptionID]  to  = ...

I'm getting an error in the formula when I use that. The Verify Formula button says: "@KPIDescriptionID" does not point to a valid location path of a field or group.   So, to confirm I'm doing everything right, let me restate how I'm pulling the data. In my Main Connection to the table AccessTestTable, I have a set of ...

I do not see Current anywhere! That may have been the problem I was having! xdXDocument:GetDOM("KPIDescription")/dfs:myFields/dfs:dataFields/d:KPIDescription/@KPIDescriptionName[../@KPIDescriptionID = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/d:AccessTestTable/@KPIDescriptionID]

 I can make it a field, but when I try pulling data from a Secondary source, it creates a separate repeating section than the repeating section created when I put the data in from the Main connection source. Since I have the drop down menus working with the Query function, and that works with the KPI ID, it may make more sense to keep it ...

Hello, I've been searching these forums for the answer to my question - and maybe I'm not using the right Infopath terminology, but I can't find exactly what I'm looking for. I hope this is a really easy answer, but it's been confounding me for several days.  I have a Scorecard based off of a table in SQL that has 4 ...