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

Posted on 2012-09-20
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
    LVL 28

    Accepted Solution

    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

    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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
    Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now