Hello! I have a list on a subsite that needs to get data from a list on the main site in MOSS 2007, but I'm having a hard time pulling it up as a value in a lookup. Is there a way to do this?Thanks!-Spazmo

Hi,SharePoint OOB functionality only supports lookup in the same site.There are other third party providers who provide cross site look up columns http://www.sharepointboost.com/Cross-SiteLookup.htmlYou can probably use a custom Event Receiver(ItemAdding event) which would be added to the Main site. When there are any new list items getting added to the list, you can also add them to the sub site list.Hope this helps.Thanks,Skancharla

Hi,There are a few free SharePoint cascading drop down, filtered lookups etc that connect lists from anywhere in the Site Collection... One of my favorites areThe SharePoint 2007 and WSS3.0 Lookup field out-of-the-box. The lookup allows creating list columns that refer some other lists in the same site. the following is one that I use SharePoint Connected Lookup http://cl.codeplex.com/However, the biggest shortcoming of the SharePoint OOB field offering is lack of hierarchal dropdowns or connected lookups. \\ This list contains about 20http://www.codeplex.com/site/search?projectSearchText=sharepoint%20lookupCheers,-IvanIvan Sanders My LinkedIn Profile, My Blog, @iasanders.

If your source list is at the top level site, the you can create a site column (by going to site settings at the top level site), which is a lookup for a list at the top level. This should then be useable on your subsite.

Thanks everyone! Hey, Steven - that looks like my best bet. Let me ask you this - is there a way for me to create a workflow so that if a new list item (in the list on the main site) is created, it will automatically create a new list item in the list on the subsite?Thanks!-Spaz

Hi,As I mentioned in my previous thread you can use either a workflow or event receiver to move the new items created at the main site to the subsite.Thanks,Skancharla

Go to your main site. Site Settings Site Column Gallery Create -> Name it Type = Lookup Existing Group -> Custom Columns Description Get Information From: (Pick the list your data is in) In this column: (Pick the column from your list that you want to use in the subsites) Click "OK" You're done, that column from that list is available to subsites!