LookUp Field in SharePoint 2010 OOTB


Today, in this article let's play around with one of the interesting and most useful concepts in SharePoint 2010.

Question: What is Lookup field?

In simple terms "It is used to establish and maintain relationships between the lists (source list and targeted list) across the server".

Step 1: Open SharePoint 2010 Central Administration and navigate to a specific site.

Step 2: Create a new custom list; see:


Step 3: Create another new custom list; see:


Step 4: The design of the company custom list looks like this:


Step 5: Creating company look up column in student list:


Step 6: The design of student custom list looks like this:


Step 7: The company list data output of the application looks like this:

Step 8: The student list data entering output of the application looks like this:


Step 9: The student list data entered output of the application looks like this:


I hope this article is useful for you. I look forward for your comments and feedback. Thanks Vijay Prativadi

MVC Corporation
MVC Corporation is consulting and IT services based company.