InfoPath Form and SharePoint UDCX data connection not returning lookup values. - InfoPath Dev
in

InfoPath Dev

InfoPath Form and SharePoint UDCX data connection not returning lookup values.

Last post 03-28-2008 10:43 AM by sboyddyn. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 03-28-2008 07:42 AM

    InfoPath Form and SharePoint UDCX data connection not returning lookup values.

    Reply Contact
    I have an InfoPath Form that has been published to a SharePoint 2007 document library.   The form uses several lookup tables for dropdown list within the form.  I have converted all of the data connections to a udcx connection on SharePoint.  All of the dropdown boxes are working from the SharePoint Forms Library except one which is an aircraft list.  I think I might know what might be the problem but I don't know how to resolve it.  I have managed to get two secondary data sources for the Aircraft but they are both accessing the same SQL view.  There are two data connections in SharePoint.  One is Aircraft and the other one is Aircraft1.   I've tried several things but nothing so far as worked.  This is what I've tried.  - Deleteing one of the connections but the form won't load at all when I do thes.  I removed the fields from one of the secondary sources, converted one of the connections to Aircraft.udcx and the other one to Aircraft1.udcx, and used only one udcx.  None of these combinations have worked.  The form works correctly if it is loaded outside of SharePoint even with both view files as secondary data sources within the form.  All of the other connections return dropdown list from SharePoint.   How can I resolve my problem?  Is there an easy way to remove one of the data sources in my InfoPath form? This is my first try at deploying an InfoPath form and I don't know coding. ThanksSandy 

     

  • 03-28-2008 08:51 AM In reply to

    Re: InfoPath Form and SharePoint UDCX data connection not returning lookup values.

    Mark as Answer
    Reply Contact

    Once you remove the data source you just need to find in your form where you were referencing it. That is what it takes. So update your drop down where it was used, etc.

    Clay Fox / Microsoft InfoPath MVP

  • 03-28-2008 10:43 AM In reply to

    Re: InfoPath Form and SharePoint UDCX data connection not returning lookup values.

    Mark as Answer
    Reply Contact

     

    I managed to delete the duplicate Aircraft connection and all of the references in the form and the form is working properly on my local computer.  The dropdown is still not working after converting the data connections and publishing the form to SharePoint.    The only thing I see different in this data connection is the view is bringing in a primary key  

    Doc_No*     

    One of the other data sources for the Engines is referencing AC_Doc_No*.  I can’t check the engine data connection until the Aircraft connection is working.  I thought maybe something else needs to be done for the SharePoint connection since the connection has a primary key.  Any ideas on why the dropdown is empty on SharePoint but works locally?

     
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.