Unanswered Sharepoint list form cascading drop down with filter

  • Wednesday, April 25, 2012 4:25 PM
     
     

    i have a cascading drop down list with a data connection

    2 columns

    i select something on column a and column b does a filter

    it seem's to be working correctly but on column b it's auto selecting the last item and will not let me change it even if i click on the drop down and select something else

All Replies

  • Thursday, April 26, 2012 7:31 AM
    Moderator
     
     

    Hi Rotor,

    Do it an InfoPath form or Designer Form?

    We can perform cascading drop down controls in InfoPath follow this blog.
    http://koobarspoint.blogspot.com/2010/06/cascading-drop-downs-with-infopath-2010.html

    Thanks & Regards,
    Emir


    Emir Liu

    TechNet Community Support

  • Tuesday, May 01, 2012 4:00 PM
     
     
    I was trying to do this with a sharepoint list form with a external data column (sql)
  • Monday, May 14, 2012 10:19 AM
     
     

    Hi Emir , 

    InfoPath dose not support external content type , how to do this using SharePoint Designer ?

    thank you 


    programming is thinking

  • Tuesday, May 15, 2012 12:23 PM
    Moderator
     
     

    Hi Rotor,

    If it is a custom list form and you want to receiver data from an external data column. Since external data is getting data from SQL, you can directly receiver data from SQL in InfoPath form. This is another way we can use external list data in InfoPath form.

    Thanks & Regards,
    Emir


    Emir Liu

    TechNet Community Support

  • Friday, June 08, 2012 6:53 PM
     
     

    Hi 

    Have a look at this article, which will guide in step by step tutorial for achieving the cascading drop down with filter in SharePoint.

    Cascading dropdown (or) Filtered Values in Lookup Columns in SharePoint

    Hope this gives you some ideas in achieving the result!


    Cheers! Maruthu | http://sharepoint-works.blogspot.com