Nick Grattan's Blog

About Microsoft SharePoint, .NET, Natural Language Processing and Machine Learning

Linking to Lists in Other Sites

with 7 comments

When creating columns in lists or document libraries you can easily create a column that links to a column in another list using the “Lookup (Information already on this site)” column type:

Lsite

You will notice that only lists in the current site are shown. What if you want to create a link to a list in another site in the site collection? You can do this using site columns – note though, this the technique described here only allows you to link to sites up the site hierarchy, and not in sub-sites.

To do this:

  1. Navigate to the site which contains the list you want to link to.
  2. Select the Site Actions + Site Settings menu command.
  3. Click the Site Columns link under “Galleries”.
  4. Click Create to create the site column.
  5. Use the “Lookup (Information already on this site)” column type and select the list from “Get Information from” and the column from this list to display.
  6. Now navigate to the list in the other site that needs to link to this list. Select Settings + List Settings.
  7. Select the Add from existing site columns. You will find the column you created in (4) listed, and when selected, will contain the link to the list in the other site.

Thanks to Yann Faure for pointing this out to me.

 

Advertisements

Written by Nick Grattan

October 19, 2007 at 10:37 am

7 Responses

Subscribe to comments with RSS.

  1. Hi,

    I have a list of Auditors, with a column Auditor, wich is a person column type.

    In a second list, ItensAuditing, I need to have a field CurrentAuditor wich comes form Auditors list (auditor column).

    So i was thinking about using lookUp, but after I point to Auditors list, the column auditor does not appear .

    Is there somenthing wrong, or this is by design ?

    Any workaroung ?

    Thanks.

    A.Jr

    October 26, 2007 at 4:44 pm

  2. Hi,

    how to make a lookup in a person column ?

    A.Jr

    October 26, 2007 at 4:47 pm

  3. It would seem that this is by design. I tried creating a computed column from the “person column type”, but the column was not shown there either! Nick

    nickgrattan

    November 14, 2007 at 4:14 pm

  4. hi,

    this metod will work on wss3.0?

    I tried to follow your instructions but I still can’t see any other columns besides the ones that already are present in the current site.

    Thanks,
    Roger (from Portugal)

    spykew

    July 21, 2008 at 12:09 pm

  5. RE: Linking to Lists in Other Sites
    Thanks for posting this. I had almost given up on trying to implement this seemingly simple functionality.
    Jim.

    JimC

    July 6, 2010 at 10:08 pm

  6. I’m using sharePoint 2010 and I can’t get this to work. What I’m trying to do is the following:-
    I have a Inventory Team Site with a List containing Stock Items.
    I have a Purchasing Team Site and a Purchase request list, on the form I want the user to be able to select a stock item from a Lookup based on the Stock List in the Inventory Team site.

    This solution sounded perfect but just will not show up when I get to Add from existing site columns.

    Realy need some help with this as I need this ability so many times throughout our sites.

    Thanks in advance for any help.

    Darren Taylor

    September 7, 2012 at 10:45 am

    • Didn’t work for me either. Just shows lists within the same domain.

      LawrenceB

      January 16, 2013 at 6:21 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: