?
Solved

Linking Choice Lists in SharePoint

Posted on 2014-01-31
1
Medium Priority
?
331 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 2000 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

765 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