LookUp Field in SharePoint 2010 OOTB

Introduction

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