Reputation: 6612
I have googled this and seem to only be able to find the same Tutorial here or variations thereof. I have two lists. Each one is on a different site. I need to make a list/view joining these two lists. One site contains basic employee data, (such as department) and the other site contains details about that department that we need to show on a high level overview of employee data.
It's sharepoint 2007, two sites, same collection
Upvotes: 3
Views: 72415
Reputation: 292
I used this tutorial.
He mentions "Please note: If your lists are on another site collection you will have to use the Connect to another library... link" and he includes a screenshot.
Upvotes: 3
Reputation: 33
Here are a couple good places that have worked for me.
Connect to Another Library in SharePoint Designer 2010
Displaying a SharePoint List from Another Team Site
Upvotes: 0
Reputation: 60047
I would use Sahil Malil's technique. However this is much the same as the link to Microsoft that you've already given. Why doesn't this do what you need?
Upvotes: 0
Reputation: 3533
Aonther way to go is to roll your own field type and make it similar to a lookup field but instead make it go fetch data from a list in a different sitecollection. I don´t have ready example of something like this but this post atleast explains how to go about constructing a custom field type.
Upvotes: 0