SQL Database Integration

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

Patrick Halstead — Tue, 17 May 2011 08:20:04 GMT

Hey DogWalker,

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

When you design the form from SQL, choose the child table. InfoPath will automagically create the updategrams for the parent and child.
Better yet, use a Web service to submit, so you can support browser forms
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,

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

loudwalker — Mon, 16 May 2011 14:35:07 GMT

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?