Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

"Lookup" data in other lists at the top level.

  Asked By: Griffin    Date: Jun 01    Category: Sharepoint    Views: 2122

I have a few clients who want the ability to have custom lists in their
subsites with the ability to "Lookup" contact information stored at the
top level to avoid duplication. EG they may want a task list to lookup
or refer to a contact which is stored at the top level.

Does anyone know of any Web Parts (Free or Paid versions) that might
allow this to happen or suggestions on how best to do this minimizing
the amount of data duplication and hence differing data.



5 Answers Found

Answer #1    Answered By: Agustin Miranda     Answered On: Jun 01

Look into "Site Columns." Basically it's a column you create and it has
Site Collection scope. You can add it to any list  in the site

Answer #2    Answered By: Arron Middleton     Answered On: Jun 01

Thanks, yes I worked it out and its a perfect solution for what I

Answer #3    Answered By: Vance Hardin     Answered On: Jun 01

Please explain the steps. I create a "Site Columns". Then I created a
Custom List with this site column and entered the values in the
parent site. But, I still cannot see this List in the LookUp from a
column (created with the Site Column definition) on a child site.

Answer #4    Answered By: Kareem Flynn     Answered On: Jun 01

To the best of my knowledge "Lookup" columns only work with columns of
other lists  within the same site. You could probably create a custom
field type through programming that would allow you to do this. But
there is no way that I know of to reference a column of a list  on a
different site from inside a custom  list on a child site using the "Out
of the Box" capability of SharePoint.

Answer #5    Answered By: Tyron Calderon     Answered On: Jun 01

While what Paul is saying is true: it is possible to create a "Lookup"
Site Column to a list  that is local to the site where the Site Column is
used and then use that column in a Content Type or List in that or any
_descendant_ sites. So, for instance, let's assume that your Site
Collection looks something like this:

/ \
/ \
A1 A2

You could create a "Lookup" Site Column called ALookup on the A site to
a list also on the A site. You could then use the ALookup Site Column in
Content Types and Lists on site's A, A1, and A2 but not Top or B.

Didn't find what you were looking for? Find more on "Lookup" data in other lists at the top level. Or get search suggestion and latest updates.