Lookup columns in SharePoint 2010

Lookup columns in SharePoint 2010 are used to establish a relationship between list items in one list and related items in another list. Though in Lookup columns are introduced in MOSS 2007, There are significant changes in SharePoint 2010 for lookup columns.

Some of the changes are:


– Now in SharePoint 2010 you can show display other columns from the target list with the lookup columns, which are also know as projected columns.

– Now in SharePoint 2010 lookup columns now support referential integrity, which prevents users from deleting an item in the target list if it is referenced in one or more items in the related list.

– Now you can configure cascade delete behavior which says if an item is deleted in the target list, all the referenced items in the related list are deleted as well.

– There is a limit which specifies the maximum number of lookup columns a query at one time which is also known as List View Lookup Threshold, can be set from Central Administration site -> Manage Web Applications -> General Settings -> Resource
Throttling.

You can also visit this article for more information on Lookup Columns.

follow my other articles:-


Add multiple lookup columns to SharePoint list InfoPath form

Get List with Lookup Column Powershell Script SharePoint 2013 or SharePoint 2010

Check out Best Alternative to InfoPath -> Try Now

free sharepoint training

SharePoint Online FREE Training

JOIN a FREE SharePoint Video Course (3 Part Video Series)

envelope
envelope

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →