InfoPath Dev

Here is what I am trying to do in my expression box: Companies[@ID = 6]/@Name However, instead of using the number 6 as my parameter for the ID, i would like to query from the main data source. So I think it should be something like this: xdXDocument:GetDOM("ClientInformationDC")/dfs:myFields/dfs:dataFields/d:Companies[@ID = my:myFields/my:ClientInformation/my:CompanyID]/@Name Basically I have the id stored in my main data source, and need to use it to get the company name from my secondary data source. It doesn't appear to like the fact that I am in a sense "joining" data sources. It doesn't seem to like the "my:myFields/my:ClientInformation/my:CompanyID" expression because I am already looking at another data source.

 To have XPath reference the main data source when it is already in the context of another, you can use xdXDocument:get-DOM():

  xdXDocument:GetDOM("ClientInformationDC")/dfs:myFields/dfs:dataFields/d:Companies[@ID = xdXDocument:get-DOM()/my:myFields/my:ClientInformation/my:CompanyID]/@Name

InfoPath will usually do this for you if you use the Select Field... button, though I think sometimes it won't be smart enough to figure out you're going back and forth between data sources.

That is exactly what I was looking for. Thanks Jimmy. I didn't know xdXDocument:get-DOM() was something that was available to me in the expression boxes.