InfoPath Dev

I'm using IP 2010, but my form is set to IP 2007 Form Filler template because that is what my users have. When I look at the GetMetrics (Secondary) connnection, i just see a dataFields node under the myFields node, Did i miss something when i created this connection?

If you look at the fields task pane for your SharePoint List data connection - do you see the Query fields? Are you using IP 2010 as well? You can use those for equivalency queries - set the SynopsisID query field to the form's SynopsisID and then execute the query to return only the rows that match.

below the video there was a download. That was it!! I also see the word document in there. This is very good information on accessing external data in infopath.  Thanks!

Yes, i'm using SP 2010, what do you mean[quote user="Hilary Stoupa"]can you use the query fields to get back just the data you need[/quote]

Are you using SharePoint 2010? If so, can you use the query fields to get back just the data you need? You'll still need to use some kind of counter to loop through the items - even if you are filtering on the SynopsisID - since the XPath you are using will only ever get the ID of the first Metrics node from your Metrics list.

My secondary data is coming from a SP list via GetMetrics.  this queries the Metrics list that has a lookup column from the Synopsis list. in the Set ID rule of the repeating section, I'm trying xdXDocument:GetDOM("GetMetrics")/dfs:myFields/dfs:dataFields/dfs:Metrics[@SynopsisID = ...

Yes, certainly, though only in filler-compatible forms (the same is true for IP 2007).  Is your form filler compatible?

I think you are right - that you need to either filter the data being returned (not sure what is providing your secondary data, so I can't really speak to that) or you need to use an additional filter when you are setting the value - like group/repeatingGroup[ID = 1][1]/field to get a field value from the first instance of your repeating group ...

In the Copy Sharepoint List Values to InfoPath Repeating section fields document, you are getting ALL of the people in the contacts list. In my case, I am populating a repeating section that is effectively a subform so i only want to get a subset of the items in my SP List. I have 2 secondary data connections to SP lists, that are in a 1 ...