InfoPath Dev

Hi,

I'm using Infopath 2003. Using Repeating Table to display data from database. I should allow the user to select specific records to export or delete operations. Planned to add a checkbox besides each record in the repeating table so that the user can select records. Question is how do I bind checkbox with the repeating table and how to find out what are the check boxes that have been checked.

Thanks,

Hello and welcome to our forum! If your form is bound directly to the database then you have to actually have that column in the database for it to show in the data source and give you a column to bind to. This means you may need to create this phantom column in the DB that is only used client side.

In terms of your submit, I think you will have to write code to submit only the checked rows though there may be a way to do it when creating the original DB submit data connection parameters such that it filters there. I'm not sure about this. To try it you would go to Tools Data connections and then try to modify your Main data connection to adjust parameters in there.

Hi,

I heard someone say that this feature might be available with InfoPath 2007. I have installed 2007, can anyone help.

Or is there a way to bind a custom control with repeating table? If someone could assist in achieving this feature, that will be good.

 Thanks,

K

Hi

If i understand you correctly you need to provide a list with a check box at the end of each line item which your users can select.  You are then looking to only filter on those records.

This can be achieved by, as is suggested above, adding a column to your data source in the repeating table for the check-box.  This would satisfy the first objective.  The second objective could achived using a button to filter the existing list to only return those records selected.  This would be done by having a filter setup that is null initially but when the button is pressed it set the value of a field to filter from where check-box is equal to "yes" and then the other results would be filtered out.

I hope this makes sense

Adam