InfoPath Dev

Hello.  I've designed an InfoPath 2007 form that querys a SQL Server database. The form displays a list of operating systems and operating system versions. I have a table called OperatingSystem and another table called OperatingSystemVersion that are linked by key.

 If I search for Windows, I get several results because of the one to many relationship with the versions (2000, XP, Vista, etc...)

I understand that I could not delete Windows because there are several child records with keys that rely on that record, but how would I delete the child records (version) that appear on the form?  I would like to make a form button to delete a specific version. Idea was to put the delete button in the repeating section so it appears next to every record but I don't know programaticly how to specify to delete the record in the row where the button is clicked.

Thanks for reading and any suggestions.

Howard 

Hello Howard,

 qRules' Delete command can be used to delete any node in your form, including specific rows of a repeating table.  I recommend using this approach rather than writing code expressly for this purpose.

This is how I solved that problem. 

1) First create a view called Delete Record.
2) In the Delete Record View
    a) Place all the fields that you need to confirm that you are deleting the correct record on the form as text box that is read only.
    b) Place a button on the form that is set to Delete & Submit
    c) Place a button on the form that will switch the view back to the original view with the repeating table.
3) In the View with the repeating table
    a) Create a column in the repeating table and add a botton with the following actions in a single rule.
        1) Set Field Value: [Unique ID from data] = [Unique ID from query]
        2) Query using data connection:Main Connection
        3) Switch View: Delete Record

This will essentially query only for that one data item and switch you to the Delete Record view.  Then you can delete that item.

Hope this helps!