Hi,

Here is sample code I use in the following scenario:

I have a repeating table with 2 fields - both are drop-down lists. The
first drop-down (ddlCustomers) pulls data from my web service automatically
when the form loads so I can get a list of customers. The second drop-down
in my repeating table (ddlOrders) also gets its records from the web
service but that web method takes a parameter (the customerID) so it does
*not* load its data when the form loads.

In the OnAfterChange event of ddlCustomers, I have the following code:

    if(eventObj.Operation == "Insert")
    {
        //Get a reference to the data object
        var objOrdersDO = XDocument.DataObjects("GetOrders");
       
        //Load the data objects DOM into a new variable so we can
        //set the SelectionNamespaces to be able to navigate the nodes
        var objDOM = objOrdersDO.DOM;

        //Set the SelectionNamespaces property
        objDOM.setProperty("SelectionNamespaces",
       
'xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSoluti
on" ' +
        'xmlns:tns="http://tempuri.org/NWTables/Service1"');

        //Get a reference to the query field from the web method
        var myQueryField =
objOrdersDO.DOM.selectSingleNode("//dfs:myFields/dfs:queryFields/tns:GetOrde
rs/tns:strCustID");

        //Set the text of this query field to the selection made from the
ddlCustomers box
        myQueryField.text = eventObj.Site.text;

        //Execute the query for the GetOrders data connection to retrieve the
records
        objOrdersDO.Query();

        //Clean up
        objOrdersDO = null;
        objDOM = null;
        myQueryField = null;
    }

I hope this helps you!

Scott L. Heim
Microsoft Developer Support

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