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.
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!