locked
Retrieving data from non-primary database RRS feed

  • Question

  • I have an infopath form published to a Sharepoint collection that does the following:

    1) The user fills out a new form. After the user enters an identifying number into one of the infopath fields, there is a secondary connection (MSSQL) that gets queried to pull data and populate a portion of the form.

    2) Step one works great and the form can be submitted to the Sharepoint collection without issue. 

    3) When a user opens that submitted form within Sharepoint (or through file share) the information that was previously populated from the secondary connection does not repopulate in the form. Deleting the identifying number from the field and reentering it causes the information to reappear. Also, if you examine the actual XML file in a text editor, the information is present...just doesnt show up on the infopath from when its opened.

    Anyone had similar experiences with this and know of the work around?

    Wednesday, July 25, 2012 11:25 PM

All replies