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