A lookup column is a SharePoint list column that retrieves its available values from another column within another list in the SharePoint site.

learn more… | top users | synonyms (1)

0
votes
3answers
975 views

Cross site lookup in SharePoint 2007

I need to add a lookup column to an existing list in a sub-site in SharePoint 2007. The data would come from a sibling sub-site. How can I do that? I see the option to add a lookup column, but that ...
8
votes
4answers
45k views

How to set ListItem Lookup Field value

How do I set a ListItem's Lookup field using code? SPFile file = list.RootFolder.Files.Add(destUrl, iStream, true); SPListItem item = file.Item; item["DocumentID"] = DocID.ToString(); ...
3
votes
1answer
455 views

How can we use multiple fields from an external list in a survey?

We are trying to build a survey, that uses data from an external list. It works fine for a single field. But what we would like to do is to bring about 10 fields back from the external system and ...
0
votes
1answer
1k views

Problem with SPFieldLookupValue in SharePoint 2010

I have an SPListItem object from a list based on a custom content type. Many of the fields in that content type are lookup types that point to other lists. When I get back the SPListItem object for a ...
3
votes
3answers
3k views

GridView lookups displaying as “id;#value”

I am using an ASP.net gridview. The datasource is SPList.Items.GetDataTable(). The gridview is working fine; however, lookup and multilookup columns display as "id;#value". Is there any way to just ...
0
votes
2answers
362 views

Hide link in Listview on Lookupfield

In my customList there are several lookups. They link to the sourcelists. My question is: How can I hide these links?
0
votes
1answer
873 views

Person/Group Lookup Field in Custom List custom new/edit form

In my Custom Newform.aspx I need a field that gives me the possibilty to insert a person or group known in the AD. How can I do this? Probably a kind of javascript or something like that. It would ...
4
votes
2answers
6k views

How to automatically link parent in child list new form?

I would have thought this would be something I could find easily with a search, but not so far. I have a parent/child relationship between two lists using a lookup column in the child. I have added ...
2
votes
1answer
2k views

Validate a date column against a lookupfields additional column

In a list you can create a lookup column which queries data from an other list, the fun part is that you can add "additional columns" which results in some sort of ghost column which is added to the ...
0
votes
2answers
3k views

jQuery Set Lookup Column Value

When using jQuery, what is the syntax to set a lookup column to a value retrieved from another lookup column. I have been able to prepopulate a string column with a value retrieved from a lookup ...
0
votes
2answers
303 views

Parent Child Forms

I am running SharePoint Foundation on Windows server 2008. When the user clicks on a list item, I would like a form to open that has child data on it for the item they selected, much like how it ...
1
vote
4answers
1k views

Add existing list as a lookup column in User Profiles

I'd like to extend my user profile properties in my SSP by adding a new property which would render as a dropdownlist via a lookup column. Is it possible to reference a sharepoint list using a ...
2
votes
2answers
2k views

SharePoint 2010 difference with lookup columns

I recently upgraded my site from SharePoint 2007 to SharePoint 2010. The first issue I noticed was that the "lookup" columns in "Display view" showed up as the hyperlink instead of the string. ...
1
vote
1answer
3k views

Sort By Descending upon lookup column

I have a lookup column in multiple lists that points to a list of dates. These dates go in ascending order, and since the list posts are sequential, the older dates start to become irrelavent, forcing ...
2
votes
1answer
941 views

Lookup site column not saving/storing metadata for Office 2007 documents?

I'm having this issue on several server environments. We have a list at the site collection root. There is a site column created as a multi-value lookup on that list's Title field. This site column ...
0
votes
2answers
328 views

Lookup from list column?

Is it possible to look-up anything but single line text values when creating a lookup column? E.g. I have a list with some general data ind it, one of the columns contains numbers. They should form ...
16
votes
1answer
21k views

How to get a SPFieldLookupValue from an SPListItem?

When you get an SPListItemCollection from a SPList.GetItems(SPQuery) request, and the items have SPFieldUser or SPFieldLookup fields, what is the sexy way to get typed values, not the ...
1
vote
3answers
3k views

Can a list be made available to column in subsite?

I am creating a project management site template. This template will be used to create PM subsites in our corporate PM site. In the subsite task list, I want to add a "Work Area" column that is a ...
1
vote
4answers
8k views

How do you connect a Calendar List to a Project Tasks list using Web Part Connections?

I created a Calendar List and a Project Tasks list. Then I added a lookup from the Tasks list to the Calendar list. However, when I try to connect the two with the related field visible on both list ...
2
votes
2answers
1k views

Maximum lookup columns - the magic number 13

So I did create on an SPWeb 20 custom lists and then a tasks list. For each of those 20 lists I've created 20 site lookup columns. I then created 20 Content Types based on Task content type. Then I've ...
3
votes
3answers
288 views

How best to handle metadata lookup?

I have a query regarding how I should best handle uploading documents into SharePoint (currently WSS) where the Taxonomy asks for client code for all documents. The problem I have is that we have say ...