Solved

Linking Choice Lists in SharePoint

Posted on 2014-01-31
1
310 Views
Last Modified: 2014-02-01
In Sharepoint I have 4 Choice Lists.  Is there a way that depending on the value selected in Choice List one, a specific list will be presented for Choice List #2 and so on.  I have a whole categorization scheme with 4 levels and I am trying to make it easy for the user to categorize.  I don't want them to have to select from the lists seperately since as you go down to the 3 level the lists get huge.

Unnfortunately IT has limited me to the basic tools within SharePoint and InfoPath.    Quite a challenge.

Thanks for your help!
0
Comment
Question by:DnGreenwood
1 Comment
 
LVL 50

Accepted Solution

by:
teylyn earned 500 total points
ID: 39826052
Hello,

what you are describing is commonly known as cascading drop-downs. The first drop-down offers, for example, a list of contintents. Asia, America, Africa, Europe etc. After selecting a continent, the next drop-down shows the countries of the selected contintent, e.g. France, Germany, Italy etc.

Microsoft has a tutorial on how to create a cascading drop-down with InfoPath here: http://blogs.msdn.com/b/bharatgupta/archive/2013/03/07/create-cascading-dropdown-in-browser-enabled-infopath-form-using-infopath-2010.aspx

You can also use Marc Andersons's free  SPServices jQuery library and manipulate the list form with SharePoint Designer to add the dependent drop-down to the form.

If you can use InfoPath, this is the easier way, with just a few clicks. The SPServices option requires installing a few files on your site and you will also need some basic knowledge of JavaScript and JQuery.

cheers, teylyn
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now