how can I get the data from the detail - InfoPath Dev
in

InfoPath Dev

how can I get the data from the detail

Last post 03-18-2008 07:33 AM by czbjack. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-18-2008 07:30 AM

    how can I get the data from the detail

    I have a form that has the main datasource as a SQL database. The database contains a parent and achild table. The parent table contains overview information and the child table contains detail.Which display as a Master/Detail.

    Problem:I want to add new records via code.But I don't know how to get the data from the detail.

    Any help?

    Thanks!

  • 03-18-2008 07:33 AM In reply to

    Re: how can I get the data from the detail

    I  got the data from the Master just like

    function btnInsert::OnClick(eventObj)

     {

    var myList = XDocument.DOM.selectNodes("/dfs:myFields/dfs:dataFields/d:Orders");

    for(var i = 0; i < myList.length; i++)

    {

     var supplierID = myList(i).selectSingleNode("@SupplierID").text;

    var deptID = myList(i).selectSingleNode("@DeptID").text;

    ....

    }

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.