In sp 2007, I have used jquery to do the cascade. But now I hear sp 2010 provides cascaded lookup. I have 3 level to drill down (Country > State > City). Is/are there any good instruction on how to implement cascaded lookup? All the lists have been created with parent-child relation.


Have a look at the $().SPServices.SPCascadeDropdowns function within SPServices.

  • @That's Marc jQuery stuff right? which I used in SP 2007. Now that microsoft has a way to implement cascaded lookup i rather use that. I am tired of maintaining codeplex code + all the 3rd party stuff we have.
    – Roxanne
    May 19 '11 at 14:27
  • CascadeDropdowns works in both versions. You shouldn't have to change anything if you've already implemented it in 2007. May 19 '11 at 14:33
  • Roxanne, The relational behavior you're describing in 2010 is limited to cascading delete, so if I delete my parent record I can set it up to automatically remove all of the child records of that record. You also have the ability to bring in multiple fields from a lookup, but it's not a cascade. The only way to cascade in a form is through UI changes such as using SPServices, you'd be doing the same thing as you did in 2007. There's some "for purchase" bolt-ons that make it "easier", but SPServices is most likely still your best bet.
    – webdes03
    May 19 '11 at 14:34
  • Also (was out of characters in my previous comment), there's a good blog post here which explains the SP2010 relational stuff pretty well: zimmergren.net/archive/2010/01/05/…
    – webdes03
    May 19 '11 at 14:35
  • 1
    Roxanne: Always happy to answer questions about SPServices over at spservices.codeplex.com. M. May 19 '11 at 17:32

Read this article, which would help you in creating the cascading dropdowns in SharePoint Cascading or Filtered Lookup columns in SharePoint

Cascading drop down in SharePoint using REST API (for SP 2013, 2016 versions & SP Online) Hope this helps you!

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.