General

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

sboyddyn — Fri, 28 Mar 2008 17:43:48 GMT

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?

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

Clay Fox — Fri, 28 Mar 2008 15:51:58 GMT

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.

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

sboyddyn — Fri, 28 Mar 2008 14:42:43 GMT

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