I am using an InfoPath form to add records to a database table. I do this by creating an External Content Type in Sharepoint Designer. Then from the content type I create an External Sharepoint List.
I then click on the External Sharepoint List in Sharepoint Designer and can then generate an InfoPath form.
I am using Code with the form so I publish with Approval.
I just wanted to know since my proposed update form will look exactly like the insert form - is there a way to re-use the form as an UPDATE form ie, editifs.aspx
I attempted to do this by editing the editifs.aspx form in SP Designer and then manually in the markup pointed the infopath webpart to my previously created insert form.
I thought that if I passed (as a querystring parameter) in the bcdidentity that the form might be clever enough to display the existing record - yes... silly me!
Anyway, not sure how to do this. Also, the insert form has a View that is already set to "Edit Item". So even if I made a copy of it - I'm not sure how to hook it up to enable editing of existing items.
Any help appreciated.