Don't load drop down list values unless selection is made in another drop down list? - InfoPath Dev
in

InfoPath Dev

Don't load drop down list values unless selection is made in another drop down list?

Last post 02-03-2011 05:11 AM by ErnestoM. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 02-02-2011 08:34 AM

    Don't load drop down list values unless selection is made in another drop down list?

    I have a form that has two drop down menu’s. Each menu is pulling A LOT of values from a SharePoint list or in some cases even a web service. I want to make it so that the values of drop down 2 don’t populate until a selection is made in drop down 1, in which case it filters the values in drop down 2 and populates drop down 2. This way, the form doesn’t take so long to load.

     

    Does disabling the 2nd drop down through conditional formatting so that it's only enabled when a selection in the first drop down is made accomplish this?

  • 02-03-2011 05:11 AM In reply to

    Re: Don't load drop down list values unless selection is made in another drop down list?

    Disabling the dropdown is not enough. You'll need to set up cascading dropdowns, which will filter the data before loading the second dropdown. For an example, please read this:

    http://www.infopathdev.com/blogs/greg/archive/2005/07/06/Create-a-Cascading-List-from-a-Hierarchical-Data-Source.aspx

    Note that InfoPath's default data connection to SharePoint will load all data into the secondary DOM, so the best you can do is limit what you display in the dropdown. The form will still contain the large amount of data. If you have a web service or a third party tool, you could perform the filtering on the server itself.

    Good luck.

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


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