Solved

Linking Choice Lists in SharePoint

Posted on 2014-01-31
1
326 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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…

705 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