1

I would like to achieve multi level lookup as below

  1. Cluster List structure enter image description here

  2. Project List structure enter image description here

  3. Project List Entries enter image description here

  4. Phase List structure enter image description here

When I select the cluster, it should show only the projects under the cluster but not all the projects?

Karthikeyan
  • 2,548
  • 14
  • 82
  • 142

2 Answers2

2

Aneenav answer uses a JavaScript library, which is a good one..

An alternative is InfoPath Forms, you can customize the Phase List Forms in InfoPath and apply additional rules with some data sources on the Project selection drop down..

You must have SharePoint Enterprise for that.

References:

Customizing SharePoint List Forms in InfoPath 2010

Cascading Drop-downs

Arsalan Adam Khatri
  • 14,531
  • 3
  • 36
  • 59
1

If you intend to do filtered lookup, take a look at jQuery plugin called 'spservices' (http://spservices.codeplex.com/). It has got a function for filtering lookup columns. You'd have to customize the new and edit form and make use of above library.

Aveenav
  • 4,199
  • 1
  • 14
  • 13