InfoPath Dev

Can I use qrules to create a secondary data connection to the same list my current main data connection is for so I can only query 9 fields instead of 85osh, then use qrules to update/save changes to those said 9 fields and submit it to the original list? Is that possible?

Just as an update, i removed the query on form load and created a button to query the data with the original data connection, it reduced the query time to around 1 minutes and 15ish seconds, which feels like forever, waiting for it while you cant do anything till its done but it did stop the form giving an error/crashing on load. I feel like ...

To better understand what I'm trying to do i attached a screenshot am i going about this the wrong way? I created a rule on the 2nd table (orange) - screenshot) on the field Ordered Quantity and said when fields changed aka when i type in it set the Ordered quantity field in the first table to the same value. I think the problem is though ...

Is it possible to only have 9 fields in a repeating table on an infopath form to only query for data when the form loads instead of it trying to query all 85 columns (fields) when only 9 show up on the actual form so it doesn't take 3-5 minutes to load the form? I tried creating a data connection to the list and only picking the 9 fields ...

 Your my hero! haha it works! :D thanks so much!!! I guess my xpath was wrong. Thousand thank yous!!!

 Tried to use the same formula as you... and got this.   "dfs:dataFields/my:SharePointListItem_RW/my:LineItemTotal/dfs:dataFields/my:SharePointListItem_RW/my:ParentID" does not point to a valid location path of a field or group.    I attached the form, I'm trying to do: ...

 How were you able to get that text box without it being mapped to anything to put the expression in it?   I see how it works, but not sure where you found that box? I'm forced to pick like text or dropdown and then it created a field on the right which id rather not have like yours... 

 Is there a way to only show the sum of a field in a repeating table for only rows that are "visible"?   I cant seem to find any info on it, only excel and access results, just figured you guys/gals would be my best hope. 

 Hilary,   I moved the rules to the drop down and the rules seem to work.   so first rule is:   None - Rule runs when field changes Actions: set fields value Ordered Quantity * Price   Then second rule is: If ParentID = to the drop down then make total show the sum of the field with the default value ...

 So for instance. I have a drop down box, and shows any (line item/row in a list) that only shows items that have a field with a value equal to the value in the drop down box. which I want the sum of a field in the repeating table to show up in a non repeating tale field "total"  I tried creating a rule on the table ...