locked
Cascaded lookup column in sharepoint 2010 RRS feed

  • Question

  • Hi,

    I have a requirement of making cascaded lookup column in sharepoint 2010. I searched on net and nothing is working for me.

    i have two list's Say ProductLine and ProductModel. Product line's title column is lookup in ProductModel as ProductLine.

    I have created a content type and custom form based on this content type using rendering templates.

    When the new item form comes, I want when i select ProductLine, respected ProductModels come in ListBox. I want list box because, i have requirement of selecting multiple productModel.

    This can be achieved using infopath.but i can not go which infopath because of  some limitation. i am also looking for the solution which will be reusable so that it can be deploy to  dev/test/prod.

    Thanks

    Manoj kumar rai

     

    Wednesday, July 20, 2011 12:40 PM

Answers

All replies

  • If I understood correctly, you just need to allow multiple values in your lookup field and you will get a listbox where you move items from left to right side. In InfoPath, this will be a list box with check boxes.
    AK
    Wednesday, July 20, 2011 12:57 PM
  • Hi 

    You are right that i need to allow multipl values in lookup field. and when we create a column by selecting allow multipl value then it comes as list box.That is not my problem. my concern is How to get respective values in listbox after selecting ProductLine.

     

    Thanks

    Manoj kumar rai

    • Proposed as answer by BigFishMachado Wednesday, June 4, 2014 2:48 PM
    • Unproposed as answer by BigFishMachado Wednesday, June 4, 2014 2:48 PM
    Wednesday, July 20, 2011 1:13 PM
  • Hi All,

    Please help me on this.

    Friday, July 22, 2011 9:11 AM
  • Not sure what exactly you'd like to do. If you want to make the form interactive (display fields based on selection), you can either use InfoPath and apply rules or use scripts - ex. http://blog.libinuko.com/2011/01/29/sharepoint-2010-how-to-create-cascading-lookup-field-using-client-object-model/
    AK
    Friday, July 22, 2011 12:51 PM
  • check this http://sp2010filteredlookup.codeplex.com/. may be it help you !!!
    Rahul Sharma -------------------------- Coding is all about passion !!!!!!
    Friday, July 22, 2011 3:17 PM
  • Hi AbedKhooli,

    I have already said that i can not go with infoapth and sharepoint designer. using them i also know how to do. So please if you know programatically, so that i can include it in my features or totally using javascript, no sharepoint designer involvment, then please help.

    My requirement is simple. I have a list which has two columns one as lookup say productline from productlines list, and one as multilookup as productmodel from productmodels list. In productmodels list Productline is the lookup column.

    So when i select the product line, respective product model should come in the product model Listbox (list box because it is  multivalue lookup)

    I am using rendering template for making the list form, sharepoint:multiplelookufield i am using. On net whatever solution i got is not for multivaluelookup column. it is there only for singlevalue lookup which comes as dropdown.  I am able to get the respective data in a datatable. but there is no methods or events in sharepoint:multiplelookupfield, so that i put this data in this field.

    Thanks

    Manoj kumar rai

     

    Monday, July 25, 2011 6:45 PM
  • Hi Manoj

    Read this article, which will help you creating cascading dropdowns using lookup columns in SharePoint.

    Cascading or Filtered Lookup Columns in SharePoint

    Eventhough it is not implemented in SP 2010 but you will get an idea for creating filtered lookup columns in SharePoint.

    Hope this helps you!


    Cheers! Maruthu | Software Developer | MCTS-SharePoint 2010 Application Development | http://sharepoint-works.blogspot.com

    Tuesday, February 14, 2012 9:15 AM
  • Hi Manoj,

    Is this issue resolved. If yes please let me know the approach.

    Thanks,

    Ankit

    Tuesday, August 7, 2012 1:15 PM