InfoPath Dev

Thanks, got it, using the following  where SynopisID is on the main form and is the lookup column in the SP List xdXDocument:GetDOM("GetMetrics")/dfs:myFields/dfs:dataFields/dfs:Metrics[@SynopsisID = xdXDocument:get-DOM()/my:myFields/my:synopsisID][number(xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)]/@ID

ok, so back to my earlier problem, how to apply a filter and step through the filtered results for each section in the repeating section. can this even be done?

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?

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]

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 = ...

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 ...

THANK YOU, i read the documentation, but since it was optional, i did not realize that it was needed in my scenario. It might help others to expand on this topic in the documentation. I am able to insert the correct the number of items in the repeating section, but they are the wrong items. I need to apply a filter to the, i think to my Insert ...

I am trying to insert multiple rows, I get the same error when i use concat("Insert /parent=/my:myFields /child=my:Metrics /count=", xdXDocument:GetDOM("ViewOptions")/Util/fields/Count) Some additional info, this is on a form that has several dropdowns that are being used to help the user choose the right item. The user is ...

Thanks

I am getting the subject error when i use concat("Insert /parent=/my:myFields /child=my:Metrics/my:Metric /count=", xdXDocument:GetDOM("ViewOptions")/Util/fields/Count). My count field shows 3, which is correct. I have attached a screen shot of my main data schema. could someone please tell me what i might be doing ...