Hi Mike,

Sorry about the delay on this...

There are a number of ways one can get records from one repeating table to
another; however, since you need to "massage" the data before copying it to
the 2nd table it makes it a bit more interesting! :-)

Here are some sample steps to copy records from one repeating table into
another repeating table.

- Create a new, blank InfoPath form
- Add a Repeating table with 2 columns
- Add a button below that table
- Add another Repeating table with 2 columns
- If you now look at your Data Source, you should see this:

    - myFields
       - group1
          - group2
             - field1
             - field2
       - group3
          - group4
             - field3
             - field4

- Right-click on the button, choose Properties and click Edit Form
Code...you should see this (other than your button name will be different)

function btnCopyRecords::OnClick(eventObj)
{

}

- In between the braces, add this code:

    var objTable1 =
XDocument.DOM.selectNodes("//my:myFields/my:group1/my:group2")
    var objXMLNodes;
   
    for(var i = 0;i <= objTable1.length - 1;i++)
    {
        var objTable2 =
XDocument.DOM.selectSingleNode("//my:myFields/my:group3/my:group4[last()]")
        if(objTable2.selectSingleNode("my:field3").text != "")
        {
            XDocument.View.ExecuteAction("xCollection::insert", "group4_2");
        }
       
        var objTable2 =
XDocument.DOM.selectSingleNode("//my:myFields/my:group3/my:group4[last()]")
        var objT1CurrentRow = objTable1.item(i);
        objTable2.selectSingleNode("my:field3").text =
objT1CurrentRow.selectSingleNode("my:field1").text
        objTable2.selectSingleNode("my:field4").text =
objT1CurrentRow.selectSingleNode("my:field2").text
    }

- Save the code, Preview the form and test. After adding text to field1 and
field2 in the table, click the button and those records should be copied to
the bottom table.

Let me know if this is what you needed!

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights