{"id":441,"date":"2009-02-08T21:32:41","date_gmt":"2009-02-08T21:32:41","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2009\/02\/08\/sharepoint-dependent-lookup-columns\/"},"modified":"2009-02-08T21:32:41","modified_gmt":"2009-02-08T21:32:41","slug":"sharepoint-dependent-lookup-columns","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2009\/02\/08\/sharepoint-dependent-lookup-columns\/","title":{"rendered":"SharePoint Dependent Lookup Columns"},"content":{"rendered":"
\n

I\u2019m getting asked this a lot, of whether you can have a choice column in a SharePoint list provide a list of values and based on the selection in that list, have another choice column display relevant choices.\u00a0 For example, if you choose Canada as a country from a \u2018countries\u2019 list, you would then be presented with a list of provinces as a \u2018Provinces\u2019 list and could choose BC, for instance.<\/p>\n

\u00a0<\/p>\n

The bad news: Nope, it ain\u2019t built into WSS 3.0 or MOSS 2007 and readily available (are you listening Microsoft, for future versions?)<\/p>\n

\u00a0<\/p>\n

The good news: The fine folks at Bamboo have webparts just for this (the one in particular is called \u201cBamboo Lookup Selector<\/strong>\u201d, and it is also available as part of their Bamboo SharePoint Custom Column 4-Pack<\/strong>).\u00a0 A quick run down of what is in the 4-Pack ($1200, the individual Lookup Selector is $300 by itself):<\/p>\n

\u00a0<\/p>\n

Reference: http:\/\/store.bamboosolutions.com\/onlinedoc\/Default.aspx?AppName=HW41AN%20Overview.html&ProductID=75<\/a><\/p>\n

\u00a0<\/p>\n

Get It: http:\/\/store.bamboosolutions.com\/ps-75-5-sharepoint-custom-column-pack.aspx<\/a><\/p>\n

\u00a0<\/p>\n