https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/92658.aspxSun, 01 Sep 2013 22:52:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:92658Patrick Halstead0https://www.infopathdev.com:443/forums/thread/92658.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=92658<p>If the other repeating table is inside the current one, you can use the same current() technique to do it. Make sure you add a filter that selects the secondary data source first and then compare it to the actual selected value field in the main data source. You should end up with two current() expressions in your xpath. If not, try again as sometimes InfoPath infers the wrong thing. You can also manually add the filter using current() but it&#39;s&nbsp;trickier.</p>https://www.infopathdev.com:443/forums/thread/92514.aspxMon, 26 Aug 2013 15:27:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:92514jorow0https://www.infopathdev.com:443/forums/thread/92514.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=92514<p>Hi, I have been trying to configure an infopath 2010 form where I have a repeating table built from a Sharepoint list which automatically completes rows based on entries within the list - basically when the form is opened a table is presented with several rows containing Expense Categories and their relevant codes.&nbsp;The form itself is for personal expenses so I have another Repeating Table which provides a dropdown selection containing Expense Categories (these are included in the Sharepoint list), so basically what happens is a user will complete rows in the first repeating table selecting the relevant Expense Category and entering an amount which will then update Category row in&nbsp;the second repeating table with a sum of the amount - using this formula - sum(xdXDocument:get-DOM()/my:myFields/my:Expenses/my:ExpenseItems/my:ExpenseAmount[current()/@Category = ../my:ExpenseCategory])</p> <p>I have now been asked to configure another repeating table that doesn&#39;t involve a drop down selection but is required to update one of the categories within the second repeating table but I am unable to workout how I can tell it what Category Row to update.&nbsp; The new Repeating Table is for Mileage Expenses so anything entered into here needs to update the total of&nbsp;Mileage Expenses row.</p> <p>I hope I have managed to explain this OK but can provide more information if required.</p>