Select Save and fill out the target list. To display more lookup information from the source list on the target list, select More options. For this example, select Title since we want to display the Course Name. Under Select a column from the list above, select the column from the source list you want to display on this list (the target list) in the new column you are creating. For this example, select the Course list. Under Select list as a source, select the source list. To add a Lookup column to the target list, select Add Column > Lookup.Įnter a name to display at the top of the column.
Let's add an Author column (single line text) and a Cost column (currency). For the example, we will add three courses: Intermediate Computer Science, Intro to Computer Science, and Machine Learning. Make list items for all the information you will display on the target list later. For example, we will make a Course list with the columns: Course Name (title), Course ID (single line text), Class Time (date and time), and Semester Length (choice, with two options: full, half).įill out the source list. This list will have columns for all the information you will display on the target list later, as well as additional information for each list item for our records. The goal is to display a course name and course ID for every book on the Reading list without having to manually enter the information. In this example, we'll use a list of college courses as the source list, and a Reading list as the target list.
To make a list relationship, you will need two lists: the source list and the target list. Managing list relationships when lists have many items Getting started with list relationships In this articleĪdding a Lookup column to an existing list Target list items can also link to and display multiple columns worth of information from the source list, and relationships can change what happens when an item is deleted (check out Deleting items with a relationship). Relationships help track and maintain information across multiple lists. List relationships let you join information from two lists and keep it consistent while people edit and delete list items. In a list relationship, information from one list (the source list) is automatically shown in another list (the target list). SharePoint Server Subscription Edition SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 Enterprise SharePoint in Microsoft 365 SharePoint Foundation 2013 Microsoft Lists More.
0 kommentar(er)
