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….
This article has been editorially reviewed by Suprotim Agarwal.
C# and .NET have been around for a very long time, but their constant growth means there’s always more to learn.
We at DotNetCurry are very excited to announce The Absolutely Awesome Book on C# and .NET. This is a 500 pages concise technical eBook available in PDF, ePub (iPad), and Mobi (Kindle).
Organized around concepts, this Book aims to provide a concise, yet solid foundation in C# and .NET, covering C# 6.0, C# 7.0 and .NET Core, with chapters on the latest .NET Core 3.0, .NET Standard and C# 8.0 (final release) too. Use these concepts to deepen your existing knowledge of C# and .NET, to have a solid grasp of the latest in C# and .NET OR to crack your next .NET Interview.
Click here to Explore the Table of Contents or Download Sample Chapters!