SharePoint - Creating a Lookup column in a Custom List
Posted by: Ravi Keshwani
in Category SharePoint
Abstract: In this article, I will show you how we can add a lookup column in a custom list which will populate its column values from an existing list, associated with it.
This is my first article for DotNetCurry.com and I am very happy to start a SharePoint Beginner Series here. In this article, I will show you how we can add a lookup column in a custom list which will populate its column values from an existing list, associated with it.
Let us assume that a custom list named ‘Team’ already exists. We want to create a new list ‘Members’ which will belong to one of the team, from our custom list ‘Team’ as shown below:
Follow the steps shown below to Create a “Members List “and add a look up column.
Step 1: Goto Site Actions > Site Settings > Site Administration > Site Libraries and List > Create New Content > Custom Lists > Provide name ‘Members’ and click create.
Step 2: You will now see ‘Members’ List in the quick launch list (to the left). To add a Look up column, Click Settings > Create Column as shown below:
Step 3: Clicking this option will display a screen where you can add a custom column. Provide a column name in ‘Column Name’ text field and then select Lookup radio button from the columns list. Provide some basic information such as Description and required field settings.
Step 4: There is a dropdown field tagged ‘Get Information From’ as shown in the screenshot below. Select the List named ‘Teams’ from it and a column name ‘Title’ from the dropdown field ‘In this Column’ and click OK.
Again select the ‘Members’ List and click new. Now the form will have a lookup field named ‘Team’ with a dropdown showing the teams.
That’s it! It was easy stuff right. Stay tuned for some more cool SharePoint tips in my upcoming articles….