Connecting a text box to 3 different lists or libraries for Infopath form SP 2007
Hi,
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
The other test that I did I used the CAML.xml file and VB code in SharePoint InfoPath to create the connection.
ASKER
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.