Connecting a text box to 3 different lists or libraries for Infopath form SP 2007

Posted on 2012-09-20
Medium Priority
Last Modified: 2013-02-05

Is there a way to do a data connection between 1 text box into separate list or libraries so that when the user updates one of the forms the same field should change on all three forms and lists?

The fields are connected now in a library but the data does not update on the other two forms or libraries.

I created the InfoPath list forms through InfoPath SP designer 2007 but I keep getting an error stating that the connection can’t be formed.
Question by:ejosep04
  • 2
LVL 28

Accepted Solution

clayfox earned 1500 total points
ID: 38418305
The library will only display the promoted field value from the form and a form has to be opened to be edited.

Lists are tougher since you have to have a form created from scratch to update a list.

So I think it would be tough. This is where using a database and have your data relationships help.

I would suggest you look into a custom SharePoint workflow.  Have one update trigger a secondary workflow process which would look up the other records and change them as well.

A lot depends on your ability to relate all three data sets together.

Good luck

Author Comment

ID: 38419074
I know that I have to open the form to edit the fields.

The items are showing in all three forms, my problem is when I edit the specific field for example Comments.  I tried that even when I had the check box checked for allow overwrites, but it did not update all the forms, I receive an error message, but it did not state what the error was.  This is where I am trying to see if @MAX  ID will allow me to edit the fields and save it with the same MRA No.  this number should not change.

I used the CAML.xml file to create the relationship and I told it that I wanted a join relationship.

Author Comment

ID: 38419160
By the way, I'm not using a database. I created a relationship thru SharePoint Designer.

The other test that I did I used the CAML.xml file and VB code in SharePoint InfoPath to create the connection.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question