Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Is it possible to have a Lookup column that points to a different SharePoint site, hosted on the same SharePoint server?

share|improve this question
    
Do you use WSS or SharePoint Server? Standard or Enterprise? 2007 or 2010? –  AlexPoint Jun 15 '11 at 14:01
    
@AlexPoint WSS I believe. I know it's 2007 and Enterprise (sortof). –  C. Ross Jun 15 '11 at 16:43
add comment

2 Answers 2

A different site yes. A different site collection no. Then you'd need to create your own custom field type. Going to another webapp is another thing altogether (security wise it can be tricky). 1 option could be to move your column to managed metadata if you are using SP2010, or use the BCS.

share|improve this answer
    
Same site collection, different site. How would I do it? –  C. Ross Jun 15 '11 at 16:44
    
By creating a site column in the root site of the site collection, include that in the content types it's needed –  Colin Jun 16 '11 at 12:29
add comment

If you create your lookup column as a Site column, then you can use it in all lists and child sites below that site.

Therefore, if you create a lookup at the site collection root, you will be able to use it everywhere in that site collection.

Sadly, there is no easy way of doing a lookup across site collection boundaries.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.