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. 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 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])
I have now been asked to configure another repeating table that doesn'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. The new Repeating Table is for Mileage Expenses so anything entered into here needs to update the total of Mileage Expenses row.
I hope I have managed to explain this OK but can provide more information if required.