How can we get Cascading Lookup Columns in sharepoint 2010?

Question

How to get the cascaded Lookup columns in sharepoint 2010,Iam having requirement like i have two lists(Category List and Sub category list)..For each item in category list i have 5 different items in sub category list..

So if i select one item(ex:Desktop) in Category list,the next column dropdown has to come corresponding items of sub category list which relates to item(Desktop) in category list..

Iam using three lists here 1)Category 2)Sub Category 3)Ticket calling category and sub category title columns as lookup columns in Ticket List..

i have searched some sites like http://www.sharepointboris.net/js/spcd/ but didnt find the solution

Could anyone help me achieve this?

Thanks, Naresh.

Thanks for commenting that you have found the answer, but it would be better if you could post an answer containing a little more detail on how you solved the problem, with the link added for reference. Thanks. — SPDoctor, Dec 20 '11 at 17:07

score 3 · Answer 1 · answered Dec 22 '11 at 06:55

3

I got the Solution from http://cascadefilterlookup.codeplex.com

answered Dec 22 '11 at 06:55

Naresh Nemuri

351
1
4
11

can you add details for the reason you chose this option over others? – Russell Dec 23 '11 at 03:00

Eric Alexander · Answer 2 · 2015-01-28T17:47:45.867

2

Its can also be done in InfoPath, I highly recommend SPservices though. Examples:

edited Jan 28 '15 at 17:47

answered Dec 19 '11 at 15:24

Eric Alexander

43,293
10
53
93

thanks for your answer...but i got solution from this link http://cascadefilterlookup.codeplex.com – Naresh Nemuri Dec 20 '11 at 10:15
@naresh if this codeplex module helped you, you should add it as answer and mark it as answer as soon as you can – Anders Rask Dec 21 '11 at 20:46
can you give me some resource to get this done in InfoPath? – Luke Jan 28 '15 at 17:43
Updated answer with links to examples – Eric Alexander Jan 28 '15 at 17:48

score 2 · Answer 3 · answered Dec 19 '11 at 20:10

2

I've used a custom field for this request in SP 2007. I don't know for sure if you can use it in SP 2010.

answered Dec 19 '11 at 20:10

Sven Gillis

1,520
12
20

thanks for your answer...but i got solution from this link http://cascadefilterlookup.codeplex.com – Naresh Nemuri Dec 20 '11 at 10:13
the questions was about cascaded lookup fields. the link you have provided is about cascaded dropdown list so it makes a copy of the text and actually does not provide a real lookup – GillouX Jan 19 '12 at 15:45
of course I was speaking about the Naresh link and not the one provided by Sven Gillis – GillouX Feb 01 '12 at 10:43

score 1 · Answer 4 · answered Dec 19 '11 at 14:01

1

Check out SPServices Jquery library which provides cascading dropdown functionality among many others: http://spservices.codeplex.com/documentation

answered Dec 19 '11 at 14:01

Ashish Patel

11,385
3
22
29

thanks for your answer...but i got solution from this link http://cascadefilterlookup.codeplex.com – Naresh Nemuri Dec 20 '11 at 10:15

score 1 · Answer 5 · answered Dec 19 '11 at 19:21

1

InfoPath is probably the easier solution to implement.

answered Dec 19 '11 at 19:21

David Peterson

61
1
6

thanks for your answer...but i got solution from this link http://cascadefilterlookup.codeplex.com – Naresh Nemuri Dec 20 '11 at 10:14
@david : can you give me some resources to get this done in InfoPath? – Luke Jan 28 '15 at 17:44

score 0 · Answer 6 · answered Dec 20 '11 at 08:29

0

If you don't mind using the Metadata, I suggest you the best way to do the Category-Subcategory-Item senario at here.

answered Dec 20 '11 at 08:29

Jony

616
4
10

thanks for your answer...but i got solution from this link http://cascadefilterlookup.codeplex.com – Naresh Nemuri Dec 20 '11 at 10:16
That tool looks good! – Jony Dec 23 '11 at 07:19

score 0 · Answer 7 · answered Feb 14 '12 at 06:10

0

I would like to share the link which would guide you in creating the cascading dropdowns in SharePoint Cascading or Filtered dropdowns in LookUp Columns Hope this helps you!

answered Feb 14 '12 at 06:10

Maruthu

51
1

score 0 · Answer 8 · answered Apr 26 '13 at 15:21

0

This is other custom field SharePoint Cascaded Lookup

answered Apr 26 '13 at 15:21

Raymond

433
3
5

How can we get Cascading Lookup Columns in sharepoint 2010?

8 Answers8

Linked