Changing Data Connection in the form - InfoPath Dev
in

InfoPath Dev

Having trouble finding a blog or post that answers your question? Check out our Custom Search Page

Changing Data Connection in the form

Last post 07-26-2012 06:24 AM by Aerial11. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 07-25-2012 11:29 AM

    Changing Data Connection in the form

    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.
  • 07-25-2012 04:51 PM In reply to

    Re: Changing Data Connection in the form

    Hi - is your text field set via a rule on the field bound to the drop down? Or is it a default value?

    If your text field is a default value, and the current value in the dropdown is no longer a valid selection (now that your drop down uses "List B" for its entries instead of "List A") that might explain the behavior.

    I'd use content types for this type of thing - then the original XML open with their original form, and the new XML will open with the template they were created with.

    Hilary Stoupa
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

  • 07-26-2012 06:24 AM In reply to

    Re: Changing Data Connection in the form

    Thank you Hillary. The text field is a default value. Now I know the reason for that behavior. Thank you very much for the suggestion.
Page 1 of 1 (3 items)
Copyright © 2003-2012 Qdabra Software. All rights reserved.
View our Terms of Use.