SharePoint 2010 Lookup Columns Additional Column Options

When creating a new lookup column type in SharePoint2010 you are given some additional column options that allow you to pull in multiple field values from the list that is being used as the lookup. Here is a screenshot of the configuration using a lookup to a Document Library-

 

In addition to the ability to show more of the lookup columns, we are given the ability to control how the list handles the relationship. This means that we can force the target list to not enable deletes for any items that are referenced in this list.

 

Here is the error screen I get when I try to delete the item in Tasks that I am referencing as a lookup in my custom list:

 

When you go to enter a new list item you select the lookup value and then the additional columns you selected are populated and available for display in views and on the view properties page for the list.

 

 

You can also, from this list select to edit the lookup value. For instance, in the example above, if I select Task 1, the display form for Task 1 is opened in a new window and I can select to modify the values. I click save and then my lookup values are immediately updated.

 

Now…the real question…how many times did you wish you could do something like this with SharePoint 2007? J This opens up a whole new realm of possibilities for quickly creating powerful out of the box SharePoint applications!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s