Link Two Lists and Display the Data Using the SharePoint Data View

Do you have two lists that you would like to display their data in one convenient location? Well, the SharePoint Data View should work perfectly for this type of use. Follow along with the article to understand more about using the Data View to connect two list and display information of your choosing.

To begin, you must have SharePoint Designer 2007 and appopriate permissions within both lists and the site(s). Also, some general understanding of MOSS is always a plus. Got it? Good, let’s continue.

Getting Setup:

1. Open the Site holding the page you wish to display the data view on in SharePoint Designer 2007.

2. Detach the Page from the Layout and Check it out so we can edit it using SPD

3. Once the page has finished loading select the appropriate Web Part Zone and click Data View > Insert Data View

You will now see the Data Source Library Task Pane on the Right Panel

Please note: If your lists are on another site collection you will have to use the Connect to another library… link

4. Expand Linked Sources and click Create a new Linked Source…

The Data Souce Properties window pops up; click Configure Linked Source…

5. Add lists you want linked from the Available Data Sources to the Selected Data Sources and click Next

6. For this example we will be using the “Join the contents of the data sources…” option; when you are done click Next

7. In the Data Source Task Pane expand the drop-down to our newly created Linked source and click Show Data

8. Select the appropriate columns from each data source and expand the Insert the Selected Fields as… drop-down and insert as either single or multiple item view (depending on your preference).

9. Now you will see the data in either a side-by-side view or stacked (depending on if you joined or merged when linking the two data sources)

10. Pretty it up a bit and make the Data View display the information how you want, save the page, reattach to the page layout and, finally, check in to major version.

Like this article? Why not leave a comment? Scroll down to do just that!

Related posts:

1. SharePoint Browser Error Solution: Datasheet View Error Problem description: If a site has a document library using the Datasheet view a user will receive the following error when trying to navigate to the site. “The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows [...]...
2. SharePoint Data View Web Part Announcements List The frontpage of any corporate Intranet should have announcements to provide site users with up to date information about the on goings of the company. SharePoint provides a number of options to make this possible. The following article will provide you with information about how to use the Data View Web Part to display an [...]...
3. Custom SharePoint List Icons Recently I was asked by my manager to create a dashboard for executive members to quickly see the progress of active projects. She explained to me that she wanted a “priority level” indicator similar to that of the KPI in a basic table structure. The color of the indicator would change depending on the status [...]...
4. Check In or Out Multiple Files in SharePoint For this tutorial we will use the Manage Content and Structure Feature in SharePoint 2007. It is a very useful browser interface that allows you to move items and yes, check in and out multiple documents. To get to this feature we will use the Site Actions Menu. Please note you must have the proper [...]...
5. Import Outlook Calendar to SharePoint SharePoint makes it very easy to export Calendars from SharePoint to Outlook.  But what if you have an Outlook calendar that you want on SharePoint?  This becomes more difficult and you could quickly find yourself lost on how to complete this task.  Don’t worry though, it’s not that hard.  The following article will explain a [...]...