2

I was Hoping that someone could help me with the problem that I have been having, I am trying to copy one repeating field from my Secondary Database Connection into my Main Database Connection. The Field in the Secondary Database connection has multiple records and I would like to copy all of them into my Main Database Connection Table.

I hope that makes sense.

Can anyone tell me if this is possible? As I have tried a number of ways but no luck

Thank you for you're time :)

Improve this question

1 Answer 1

Reset to default
1

The only approach I would see feasible is to use InfoPath with Code and attempt submission. For this, your primary connection must also support "Receive" data.

Alternative is also (i would recommend better) to consider using 2 external Lists as Data sources in SharePoint and rely on those - example here http://go.limeleap.com/community/bid/289541/Creating-InfoPath-Forms-that-Save-to-SQL-Server-Database

Advantages are many, particularly the ease of InfoPath form creation, security, etc. however Repeatable Sections can only work if instead of using "Edit form with Infopath" in the ribbon, you go for Forms Library with a Form using these 2 data sources.

Improve this answer
2
  • Thanks for your reply Marius, I'm afraid the only option that is feasible for me is to, use InfoPath with Code and attempt submission. I would be grateful if you could advise me on how to start the VB code?
    – user34796
    Commented Jan 13, 2014 at 9:32
  • Be aware that adding code to the form, changes it to Administrator-published InfoPath form, requiring the solution deployment in SP-CA. A good series i found johanolivier.blogspot.ch/2010/08/…
    – Marius Constantinescu
    Commented Jan 13, 2014 at 13:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.