I have a form form that is looking up a list list

It is pulling in all of the degrees list with degrees

When I enter a field into the field box, say Fireman, it still pulls down ALL of the Degrees options. list with Field

I want it to autopopulate with the Degree associated with that Field from the Fields and Degrees Test List.Field with Degree only

Any help? Thanks.

  • You might have to change the way to entered your data, but if you have a look at this link you can find a solution for "depended lookups" which sounds to me like excately what you're trying to do.
    – Andreas
    Jun 23, 2015 at 15:46
  • I followed your link and did a search for "depended lookups" as you suggested, but it comes up with 0 entries.
    – Anonymous
    Jun 23, 2015 at 21:35
  • I'm Sorry Lauren, but the search term is cascding dropdown and this is the documentation.
    – Andreas
    Jun 24, 2015 at 10:46

1 Answer 1


What you should look for is Cascading filters sharepoint and infopath.

Cascading filters is the most common term to describe what you want.

This page explains it very well as well as the video



Apologies for not writing the whole tutorial, as you can see it is quite long.

  • Thank you Susan. I followed this video up to 3:35 when he started talking about InfoPath. Unfortunately I can't use InfoPath. Do you know how to do it without using InfoPath? I know it can be done, because I've been told it used to work, and we've never had InfoPath. Thank you.
    – Anonymous
    Jun 25, 2015 at 15:57
  • It is not possible without Infopath because the latter allows you to link together the 2 lists in the way you want them to. I guess you could do the same with SharePoint Designer but you need to know how to code and it is a lot harder than what you see in the video done with infopath. Infopath is free and does not damage the platform.
    – susan
    Jun 25, 2015 at 16:09
  • Thank you. We had it working previously, but it's possible that the person that established it did something with the code (he seemingly did everything to make this site as complicated and far from out-of-the box as he possibly could before he handed it over). I've been trying to push InfoPath (in all my jobs), but have been told it's not a possibility right now due to cost (we have maybe 50 employees that would need it). Thanks.
    – Anonymous
    Jun 26, 2015 at 14:26
  • Lauren, check better because Infopath is free if you have volume license for Office Professional.
    – susan
    Jun 26, 2015 at 15:10
  • I think for some reason we don't. :( I'll use this post as backing to promote us getting it. Thanks.
    – Anonymous
    Jun 26, 2015 at 16:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.