locked
Cascading Drop Down list in newform.aspx page RRS feed

  • Question

  • I have two list, List A and List B . In List B I have used some column of List A as a look up.

    In Newform of List B the value are showing as dropdown. My Requirement is when I select 1st drop down the corresponding value should get selected in the 2nd drop down.

    Again If I will select the 2nd drop down the 1st drop down should be auto selected based on the corresponding value.

    Wednesday, April 22, 2015 11:58 AM

Answers

  • Hi,

    Please check the below

    http://www.c-sharpcorner.com/UploadFile/sagarp/cascading-drop-down-list-in-sharepoint-2010-list-using-jquer64/


    Please remember to click 'Mark as Answer' on the answer if it helps you

    Wednesday, April 22, 2015 12:11 PM
  • Hi,

    You can use the SPCascadeDropdowns function of SPService.The SPCascadeDropdowns function lets you set up cascading dropdowns on SharePoint forms. What this means is that you can enforce hierarchical relationships between column values. The function uses the GetListItems operation of the Lists Web Service to refresh the allowable values based on relationships which are maintained in reference lists. By implementing this function, there are no coding requirements to manage the hierarchical relationships (once it is in place) and you can let your users manage the content in the reference lists.

    This function works with any number of options in the dropdowns as well as multi-select parent and child columns, as shown in the following table. This is significant because each of the three column types are rendered significantly differently by SharePoint.

    For more information, you can refer to the article:

    https://spservices.codeplex.com/wikipage?title=%24().SPServices.SPCascadeDropdowns

    http://www.codeproject.com/Tips/758909/Two-Level-Cascading-Drop-Down-in-SharePoint-using

    Best Regards,

    Eric


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Thursday, April 23, 2015 12:53 PM
  • Hi,

    You can achieve this by using infopath and creating rules to link those two dropdown columns.

    Thanks,


    norasampang

    Thursday, April 23, 2015 4:56 PM

All replies

  • Hi,

    Please check the below

    http://www.c-sharpcorner.com/UploadFile/sagarp/cascading-drop-down-list-in-sharepoint-2010-list-using-jquer64/


    Please remember to click 'Mark as Answer' on the answer if it helps you

    Wednesday, April 22, 2015 12:11 PM
  • Hi,

    You can use the SPCascadeDropdowns function of SPService.The SPCascadeDropdowns function lets you set up cascading dropdowns on SharePoint forms. What this means is that you can enforce hierarchical relationships between column values. The function uses the GetListItems operation of the Lists Web Service to refresh the allowable values based on relationships which are maintained in reference lists. By implementing this function, there are no coding requirements to manage the hierarchical relationships (once it is in place) and you can let your users manage the content in the reference lists.

    This function works with any number of options in the dropdowns as well as multi-select parent and child columns, as shown in the following table. This is significant because each of the three column types are rendered significantly differently by SharePoint.

    For more information, you can refer to the article:

    https://spservices.codeplex.com/wikipage?title=%24().SPServices.SPCascadeDropdowns

    http://www.codeproject.com/Tips/758909/Two-Level-Cascading-Drop-Down-in-SharePoint-using

    Best Regards,

    Eric


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Thursday, April 23, 2015 12:53 PM
  • Hi,

    You can achieve this by using infopath and creating rules to link those two dropdown columns.

    Thanks,


    norasampang

    Thursday, April 23, 2015 4:56 PM