There are situations where it is useful to link data in one list to another list. For example, if you have a list of projects and a list of tasks. Some of the tasks are going to be associated with a project. You can easily create a reference to the project list from items in the task list.
I’m going to assume you have your two lists created; for this example I used two custom lists, but that isn’t necessary. On your list you want have a reference (the task list in my example) you need to add a lookup column:
First you need to go to the settings for the list that you want to reference the other list. In my example this is the tasks list
Next you need to create the new column in the list.
This new column needs to be a Lookup column. This will allow you to select your other List in the “Get information from:” box. You can see I have selected the ProjTest list I created for this example. You also need to specify which column in the list that you want to key on.
This is the only way so far that I have found to reference one list from another list. One work around is to add a single line of text column and have the user input a link to the list view that you want. I would like a way to reference another list or list view without user input.
