I have written some C# code to update a field with a value from a
secondary data source when a related field is selected in a drop down
list. This works fine, except when the fields are held in a repeating
section. It works for the first instance of the section, however not if
I insert any further occurrences.
I guess that I have to get current() into the code somehow, however I
cannot work ou how.
Can anyone help?

//Update the unit field with the unit held on the secondary source for
the selected product

IXMLDOMNode NodeUnit =
thisXDocument.DOM.selectSingleNode("/ABWOrder/Order/Details/Detail/UnitCode");
IXMLDOMNode NodeProduct =
thisXDocument.DOM.selectSingleNode("/ABWOrder/Order/Details/Detail/BuyerProductCode");
IMLDOMDocument3 oSecondDoc =
(IXMLDOMDocument3)thisXDocument.DataObjects["GetPermProducts"].DOM;
oSecondDoc.setProperty("SelectionNamespaces",
"xmlns:s0=\"OPD\"
xmlns:dfs=\"http://schemas.microsoft.com/office/infopath/2003/dataFormSolution\"

xmlns:my=\"http://schemas.microsoft.com/office/infopath/2003/myXSD/2005-11-22T13:55:56\"

xmlns:xd=\"http://schemas.microsoft.com/office/infopath/2003\"");

IXMLDOMNodeList oNodeList =
oSecondDoc.selectNodes("/dfs:myFields/dfs:dataFields/s0:GetPermProductsResponse/s0:GetPermProductsResult/NewDataSet/products");
foreach (IXMLDOMNode oN in oNodeList)
{
if(oN.selectSingleNode("article").nodeTypedValue.ToString()==NodeProduct.nodeTypedValue.ToString())
{                           
NodeUnit.nodeTypedValue=oN.selectSingleNode("unit_code").nodeTypedValue;
}
}