InfoPath Dev

Hi, I have a repeating table which is populated from a SQL Server database ExpenseReport. The ExpenseReport table will have a last column "Claim" that can take 2 values either 0 or 1. How do i achieve the followng:

• The repeating table will have a checkbox control in the last column. When the table populates from the Sql db ExpenseReport the checkbox should be checked automatically depending on the value in the table  1-checked 0-unchecked. After the table loads the user can check or uncheck more rows
• When the user clicks a button, we should be able to segregate the rows which are checked. How do i access the status of the checkbox?

Appreciate any help regarding this. Thanks in advance.

The check box is bound to a field in the DOM. Just use an XPath that points to that field to which the check box is bound.

/Root/Table/Row/CheckBox

If you want a specific one:

/Root/Table/Row[Number]/CheckBox