How to Link Lists in SharePoint
- 1). Click "File" and "Open Site," then choose the site or folder holding the list.
- 2). Right-click on the list or page within the folder. Select "Detach from Page Layout" in the drop-down menu.
- 3). Select the "Data View" tab and choose "Insert Data View."
- 4). Expand "Linked Sources" in the Data Source Library, then select "Create a New Linked Source."
- 5). Highlight the lists that you want to link in the "Available Data Sources" pane. Click the "Add" button to move the lists to the "Selected Data Sources" pane. Click "Next."
- 6). Choose either to "Merge the Contents of the Data Sources" or "Join the Contents of the Data Sources" option. Click "Finish." The lists are now linked in SharePoint.
Source...