Using infopath to insert a header record and multiple detail records into SQL 2008 - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Using infopath to insert a header record and multiple detail records into SQL 2008

Last post 05-17-2011 01:20 AM by Patrick Halstead. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-16-2011 07:35 AM

    Using infopath to insert a header record and multiple detail records into SQL 2008

     

    I would like to design one form that accepts input for 2 different tables and then inserts that data.  The table structure is a header table and a detail table.  So for a stupid example lets say the tables are tblanimalheader and tblanimaldetail.  I would like the form to accept the header value of dog and multiple detail records of mutt, doberman, retriever, huskie, etc.  The submission would result in one header record being created (dog) and multiple detail records being created.  Lets assume that there is an identity column that relates the 2 tables. 

     

    Help please?

  • 05-17-2011 01:20 AM In reply to

    Re: Using infopath to insert a header record and multiple detail records into SQL 2008

    Hey DogWalker,

    Seriously, what's the issue? This works in myriad ways:

    1. When you design the form from SQL, choose the child table. InfoPath will automagically create the updategrams for the parent and child.
    2. Better yet, use a Web service to submit, so you can support browser forms
    3. Best of all, use a loosely coupled data-driven Web service like Qdabra's DBXL which you could download (free trial) and set up to do yoru mapping in less than 30 minutes, or it's free

    Let us know what your specific issue is....

    Peace be with you,

    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (2 items)
Copyright © 2003-2018 Qdabra Software. All rights reserved.
View our Terms of Use.