How do you link Sharepoint Lists across different sites

Question

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

Do you mean between lists across site-collections or between lists in sites in the same site collection? — Colin, Aug 06 '09 at 07:38
Colin's question is rather important to your answer as most 3rd party tools only provide the ability to join across lists on sites within a single site collection. — Charlie, Aug 06 '09 at 12:24
Thank you, that is indeed an important question. They are different sites in the same site collection. — Russell Steen, Aug 06 '09 at 14:01

score 3 · Accepted Answer · edited Jul 08 '13 at 09:39

3

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.

edited Jul 08 '13 at 09:39

newbie

1,230
1
12
21

answered Aug 06 '09 at 19:41

Brian

292
1
2
7

thanks! I bet I just missed that link in the other tutorial. This was the tip I needed. – Russell Steen Aug 06 '09 at 20:05
1

The updated link is [here](https://www.nothingbutsharepoint.com/sites/eusp/pages/link-two-lists-and-display-the-data-using-the-sharepoint-data-view.aspx). – newbie Jul 08 '13 at 09:22
1

Updated link is also dead. – Ali Mar 07 '19 at 01:10

score 0 · Answer 2 · edited May 23 '17 at 10:27

0

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.

edited May 23 '17 at 10:27

Community

1
1

answered Aug 06 '09 at 07:48

Johan Leino

3,473
1
26
27

score 0 · Answer 3 · answered Aug 06 '09 at 08:31

0

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?

answered Aug 06 '09 at 08:31

Alex Angas

59,219
41
137
210

Because I need to connect lists from multiple different sites. In SPD, using his technique, you are only given the option to connect to lists in the site you are currently connected to. – Russell Steen Aug 06 '09 at 13:55

score 0 · Answer 4 · answered Dec 19 '12 at 19:30

0

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

answered Dec 19 '12 at 19:30

Keith

33
7

How do you link Sharepoint Lists across different sites

4 Answers4