Hello all,
I have a question regarding data connection in infopath form. If we change the data connection in the form template then what will happens to the forms based on that template and are already submitted to the library.
For example, I have two lists. List A and List B. List A has 3 columns, column1 column2 and column3 of type single line of text. List B also has three columns, column1 column2 and column5. I have infopath form template published to FormsLibrary1, that reads the data from List A. It reads the data from Column1 and Column2. Form also has two fields. Field1 is a dropdown which gets data form List A column1. Field2 is a text box. Depending on the value of Field1, it will get the respective value of ListA column2. Its a browser enabled form and couple of forms based on this template has been submitted to the FormsLibrary1.
Now I need to change the data connection in the infopath form. the change is instead of reading the data form List A, I need to get the data from List B, column1 and column2. So field1 gets the value from List B column1 and respectively gets the value of Field2 from List B column2.
I added the new data connection to the form, added it into the dropdown and also made change in the formula of field2. then published the form. But when I open the previously submitted form from FormLibaray1, I can see the values in Dropdown box i.e field 1. But the field 2 is blank. If I change the value of field 1 then field 2 also gets updated.
Can someone explain me this and tell me what I am missing or what I did wrong. and also can someone guide me how to change the data connection without affecting the previously submitted forms.
Any help is greatly appreciated.