What is Look up Column and how to use in SharePoint 2010,2013

Hi Guys,

Thanks for visiting my blog .

Look up Columnin SharePoint 2010 and 2013

When you create a column, you can specify that the column must contain unique values. This means that the list cannot have any duplicate values in that column. You cannot add a list item that contains a duplicate value, modify an existing list item that would result in creating a duplicate value, or restore an item from the Recycle Bin if it would result in a duplicate value. Furthermore, if you create a lookup column in a source list, and you define that column to be unique, the column in the target list must not contain duplicate values.

Note    Uniqueness is not case-sensitive, so for example, ORD-231 and ord-231 are considered duplicate values.

A unique column must also have an index. When you create a unique column, you may be prompted to create the index and it is automatically created when you click OK. Once a unique column has an index, you cannot remove the index from that column, unless you first redefine the column to allow duplicate values.

How to create a look up column in SharePoint 2013 ,2010 ?

I am going to create a look up column in step by step process...Please follow the same .


1. Create a Custom List  "TestListA" . Create a  column "place (DataType: Multiline Text box I   have  taken as per my requirment) and add some data to it.


   




 2. Create another List "TestListA". Now Create new column Name Place and select the datatype        Lookup feild



3 After selecting the Column from the  another list . Please click on the save button and then open the list and try to add new item.

            


4. At the time of creating the look up column if we select the "Allow multiple values" check box.
   then  the above form will be looking like below screen.
            
      
  


This is how we create a sample look up column in SharePoint 2010 as well as SharePoint 2013.

Hope this Post will help you .......