SharePoint Blogs / SharePoint University
SharePoint Blogs and SharePoint University - all in one place!
Need SharePoint Training? Attend a SharePoint Bootcamp!

Please delete cookies related to sharepointblogs.com and sharepointu.com to resolve login issues!

How to create cross-site list lookups in MOSS/WSS 3.0

(Resurrected by request from the pre-crash blog posts)

Setting up the lookup list
1. At the top level site use the /_layouts/create.aspx page to create a list with a column that contains the items you want to lookup to.
2. From the Site Settings > Site Column Gallery create a Custom Site Column that uses a lookup field to the new list and column from step 1.

Using the new lookup
3. At your chosen location in the site hierarchy, go to the settings for the list/library where you want to add your lookup and in the Columns section, click Add from existing site columns
4. Select your new Custom Site Column from the list (use the groups menu to filter and locate your list depending where you added it, either to an existing column group, the default Custom group or a newly defined custom group), and add across.
5. The new lookup column will now appear in your list/library.

 


Posted 11-19-2008 10:10 AM by agoodwin

Comments

KSB wrote re: How to create cross-site list lookups in MOSS/WSS 3.0
on 03-24-2009 3:19 AM

This lookup is for top level site to sub-site. Is it possible to create from one sub-site to another sub-site, residing in the same main site?

Ceesaxp wrote re: How to create cross-site list lookups in MOSS/WSS 3.0
on 07-03-2009 1:38 AM

I've been wondering about much the same -- I'd like to do cross-site look ups, not parent-child ones.

Add a Comment

(required)  
(optional)
(required)  
Remember Me?
Need SharePoint Training? Attend a SharePoint Bootcamp!
Posts (c) their respective authors. Everything else (c) 2009 SharePoint Experts, Inc.