SharePoint - Creating a Lookup column in a Custom List
Posted by: Ravi Keshwani ,
on 9/18/2010,
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….
Was this article worth reading? Share it with fellow developers too. Thanks!
Ravi Keshwani is an MCA with 5+ years of experience in Microsoft Technologies.