Thursday, August 27, 2009

SharePoint Mulitple Field (Connected) Lookups

Another project, another roadblock thrown up by SharePoint.
We needed the ability to look up multiple values off of one field-basically we needed a Phone, Fax, email based off of a name. This is where Codeplex comes into play, and the Connected Lookups Solution that Leonid Lyublinski of Microsoft created, fits in with this need.

This solution creates a new Column Type for your list, Connected Lookup Field, that uses the basic lookup functionality and upgrades it considerably. It creates a "Parent Column" that is the reference point for the subsequent "Value Columns". This is what it looks like:


There are some limitations in regards to list size (1000 items seems to be the most it can handle) as well as some nesting issues that Leonid references here.

The Code itself is available for Download from Codeplex here. It is an automated install, very simple to perform, and once it is installed, very easy to use.

No comments: