SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 3 down vote accepted

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

share|improve this answer
@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. – Eric Alexander 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:… – webdes03 May 19 '11 at 14:35
Roxanne: Always happy to answer questions about SPServices over at M. – Marc D Anderson May 19 '11 at 17:32

Have a look at this article -

Hope it helps too. :)

share|improve this answer

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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