Linking Choice Lists in SharePoint

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!
DnGreenwoodAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.