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)

1
vote
0answers
570 views

Why does SPMetal ignore lookup columns in Farm Solution

I have content types and related lists (via lookup columns) in a Sandbox solution(.wsp). All my lookup column relationships come up fine in the SPMetal generated entity classes. I now have a ...
0
votes
1answer
481 views

Fix a lookup type site column when website is provisioned

The site column "Related Task" is lookup type. I would like to fix this column's "Get information from" table. The get information table is within the same site. Is it possible to fix this using using ...
0
votes
3answers
11k views

How to implement Cascaded lookup in SP 2010?

In sp 2007, I have used jquery to do the cascade. But now I hear sp 2010 provides cascaded lookup. I have 3 level to drill down (Country > State > City). Is/are there any good instruction on how to ...
2
votes
3answers
920 views

Sharepoint2010 Lists Lookup

I'm creating 3 lists using Sharepoint 2010 UI. The lists and relationship are as follows: Training (parent) -> Training Instance (child, look up Training ) -> Training Session (grandchild,lookup ...
1
vote
1answer
2k views

Allow multi-selection for a field based on an external content type?

The choice field and lookup field allow for multiple selections. I can't find that option for lookups to external content types. Is it possible to do this? (I want to assign documents to one or more ...
1
vote
1answer
470 views

Accessing Lookup Values fails with Exception when the connected user is not the SharePoint Site Collection administrator

In sharepoint 2010 Foundation, after we installed a simple event receiver that mainly runs when certain items are added/modified, we noticed, during manual testing, that if we logged in as a user ...
1
vote
2answers
2k views

Display form containing lookup field opens new window, how to change this?

On any list in SharePoint 2010, when you open the details view for a list item, you get presented with the display form. If the details view for a list item contains a lookup field, it is displayed ...
0
votes
0answers
698 views

using list lookup Fields in SharePoint 2010 programmatically [duplicate]

Possible Duplicate: How to set ListItem Lookup Field value I have a SharePoint list with a lookup field and I want to add values to this list through the SharePoint Object Model. but I ...
7
votes
3answers
3k views

Multiple Lookup field , how to return better deliminators using object model?

I have a multiple lookup field, and when I do this: string myValue = oItem["MyLookupField"]; I get this string back: [id];#[displayText];#[id];#[displayText] or a real example: "5;#C3;#15;#P3" ...
4
votes
1answer
585 views

Lookup to list with permissions

i'm trying to achieve something that i'm not sure if it's possible or not. I have a News system that uses multiple lists, permissions etc. The permissions exist because only 1 person is able ...
2
votes
2answers
1k views

Create Site Column (lookup type)

Is there any solid (proven) method of creating Site columns (lookups) where list GUID is not known? I think this is where feature activation kicks in; getting the lookup list by its name and then ...
7
votes
3answers
2k views

Replace semicolon delimiter in a Lookup column on the list view

When selecting multiple values, the data is separated with semicolons. When many values are selected it starts looking cluttered. Is there any way to have each value on a new line? For example, ...
1
vote
3answers
4k views

Content Type Hub Syndication and lookup site column within a content type

I am a content type which has to have a lookup field. I have created two exactly identical lists in hub site collection and the consumer site. Then I created the lookup site column and added to the ...
1
vote
1answer
2k views

Programmatically generated Lookup Field causes “System.ArgumentException: Value does not fall within the expected range” when creating new item

I created a content type TypeA that has a lookup field to basic ListB. Then I create a ListA that uses TypeA. Everything is created programmatically. An exception is thrown when ListA's 'add new ...
0
votes
3answers
965 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 ...
7
votes
4answers
42k 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
453 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
359 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
861 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
5k 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
301 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
917 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
324 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 ...
15
votes
1answer
19k 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
2k 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
284 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 ...