InfoPath Dev

Well, I'm going to answer my own question and I feel pretty dumb.  I unchecked the default value box "Update this field....recalculation" and it quit resetting the default value when I opened the field. But it also didn't put in an RC default value for the first expense item in the repeating table.  I had to add a rule ...

I'm making changes to the Expense Report template that comes with Infopath 2007.  The employee department is being filled automatically with Sharepoint User information.  In the expense items repeating table, I have added a column for the department field, but have defined it as a new field called RC.  RC has the default value ...

Thanks so much!  I'm still learning and hadn't found the position function. 

Is there a way to have a control in a repeating table to be an autonumber, so that each time a new row is added to the table the content of the field increases by one?  It would be like numbering the rows.  I need to have this number so the user can enter it into another repeating table on the form, creating a reference between the ...

Now I need to go a step further. For each expense item entry, I have added a dept # column.  In the GL total section I added at the bottom of the form, I still need to sum the amounts of the expenses grouped by the category.  But in addition to that, I need to also group by dept # within the category.  So, in the GL section I ...

I kept searching and found in another blog the answer I needed.  In the blog I found how to reference a particular row in a repeating table based on a condition. In the GL amount expression box data source, I used sum(/my:myFields/my:group1/my:group2[my:category = "entertainment"]/my:amount)   Thank you Matt Faus!

I am starting with the InfoPath Expense Report template.  I have added a section at the bottom of the form, that has a GL entry for every category that can be chosen in the Itemized Expenses section. What would be the easiest way to get the total of the amounts for each "category" chosen in the Itemized Expenses ...