Answered by:
Cascading Drop Down list in newform.aspx page

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
- Marked as answer by Wendy DZMicrosoft contingent staff Monday, May 11, 2015 3:06 AM
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.- Proposed as answer by Wendy DZMicrosoft contingent staff Friday, May 8, 2015 11:10 AM
- Marked as answer by Wendy DZMicrosoft contingent staff Monday, May 11, 2015 3:06 AM
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
- Marked as answer by Wendy DZMicrosoft contingent staff Monday, May 11, 2015 3:06 AM
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
- Marked as answer by Wendy DZMicrosoft contingent staff Monday, May 11, 2015 3:06 AM
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.- Proposed as answer by Wendy DZMicrosoft contingent staff Friday, May 8, 2015 11:10 AM
- Marked as answer by Wendy DZMicrosoft contingent staff Monday, May 11, 2015 3:06 AM
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
- Marked as answer by Wendy DZMicrosoft contingent staff Monday, May 11, 2015 3:06 AM
Thursday, April 23, 2015 4:56 PM