Data Connections

Re: Insert a new record

Bill — Tue, 22 Apr 2008 18:18:46 GMT

Clay,

My email address is bfringer@lsaservices. I think I would be interested.

My approach right now is generating an SQL script that will copy the current record set based on current ID and then perform a paste and append to the Main Data Connection. I will then read the new record ID and query the data connection for the new record.

Thanks !

Bill

Re: Insert a new record

Clay Fox — Tue, 22 Apr 2008 18:11:11 GMT

If you have that many tables you should really look at using web services since your complexity outstrips the basic functions in InfoPath's connectivity model and is difficult to manage as you are finding.

You can use code to template a record or with web services there may be some ways to architect it to give this functionality.

If you would like to see a demonstration of InfoPath and SQL interaction via web services and discuss your requirements, send me an email.

Insert a new record

Bill — Tue, 22 Apr 2008 17:57:08 GMT

Is there any way to copy or create a new record(s) from the data associated with the current record (DOM node). In other words: I need to perform a copy and then do a paste append to the main data connection and then open that record for editing within the form.

I know that I can use the New Record fucntion in the button properties but I want the data of the current record copied (DOM node) to the new record. I am using backend SQL tables. I have approixmately 20 tables in the main data connection.

Any help would be appreciated.