SharePoint: Lookup a Lookup Column in a List

Question

I have three lists that look like this:

Initiatives
-----------
Initiative (single line text)

Themes
------
Theme      (single line text)
Initiative (Lookup from Initiatives:Initiative)
Points     (number)

Features
--------
Feature    (single line text)
Theme      (Lookup from Themes:Theme)
Points     (Lookup from Themes:Points)     # <- This here works fine.
Initiative (Lookup from Themes:Initiative) # <- This here is busted and can't do.

See that last line there... Initiative (Lookup from Themes:Initiative) <- that's me trying to get the initiative associated with the Theme. I've tried about a bazillion different things and just cannot figure out how to do this.

Is it even possible? If so, how?

FWIW - I am using SharePoint 2010 and can use anything from the web tools to SharePoint Designer. I'm an admin on the SharePoint Site but not on the Server.

Answer 1

You cannot do that, what you need to do is use a cascading lookup field (a custom field that enables filtering one lookup according to the value[s] selected in the parent loookup. Then you can set up two lookup columns in your Features list, the first looking up the Initiatives list, the other - Themes list. Once you select a value in the Initiative, only the relevant values are available in Theme.

An example of a field like this is http://infowisesolutions.com/product.aspx?id=ConnectedFields2007 (from our company :)), but there are other solutions as well.