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
2answers
73 views

Is there any tool that can convert 2007 text/option field type into Managed Metadata fields

we have a 2007 farm that we are rebuilding in 2010. I want to take advantage of some of the new feature like Managed Metadata and I was wondering if there were any good tools out there that can ...
2
votes
1answer
2k views

Sharepoint - Creating lookup field to list on site collection scope

I've got a big problem with creating Lookup field between two lists which are deployed on site collection scope. I've got this field definition: <Field ID="{c80e8e3c-7124-4772-a39d-5b69f131d542}" ...
1
vote
1answer
881 views

Item Editor form for list - use a lookup table for dropdown

We have a list on SharePoint 2010 called "Policies". It contains a couple of dropdown boxes which point to custom columns. These columns get their data by going to List Settings > clicking on the ...
1
vote
1answer
475 views

linking a document to another document

our setup for document library as follows. We have bunch of document sets (200 doc sets to be exact) in a document library. Each doc set is for particular vendor. We place contracts in each document ...
0
votes
1answer
424 views

Restrict item in List from modification if used in other Lookup or Cascading Drop-down field

Currently I have three lists. The 1st list contains a single column. The 2nd list contains two columns - one of the columns performs a lookup on the 1st list. The 3rd list contains three columns - ...
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 ...
1
vote
1answer
3k views

Get related items from a parent list item through lookup

I've got 2 lists: Companies and Employees. In Companies I have a text field called Name and in Employees I have a lookup to Companies based on the company Name. What I'm trying to achieve is to get ...
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 ...
1
vote
1answer
81 views

How to tell if a column is a valid lookup reference?

When creating a lookup column in SharePoint 2007 the user interface restricts the available columns to a subset of all columns in the list. How does SharePoint decide which columns are available? The ...
1
vote
0answers
1k views

Inserting new item in list with EntityRef field to User Information List using Linq to SharePoint

I have a list with SPFieldUser field type in it. I try to insert new item in this list using Linq 2 SP. So, I generated data context class using the following configuration file: <List Name="User ...
3
votes
3answers
2k views

Export Import Library with Lookup column

I did export operation of custom library in Central Administration. Library has some custom fields and Lookup field on existing library on the site. After exporting main library and all dependecie ...
0
votes
1answer
64 views

How to test lookup?

When creating a workflow, is there any way to test the look up values? For instance, I have a 4-level look up which finds the manager of a user who is entered on the form. I'd like to be able to see ...
1
vote
2answers
651 views

SharePoint 2010 Lookup IE more than 20 items

Is there a way to stop SharePoint lookups in IE from becoming a text input when there are more than 20 items?
0
votes
2answers
209 views

Is it possible to have a lookup column that points to a different site?

Is it possible to have a Lookup column that points to a different SharePoint site, hosted on the same SharePoint server?
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
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 ...
1
vote
1answer
477 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 ...
0
votes
1answer
488 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 ...
4
votes
1answer
639 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 ...
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 ...
0
votes
1answer
875 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 ...
0
votes
2answers
329 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 ...
0
votes
3answers
979 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 ...
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 ...
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 ...
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 ...
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
950 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 ...
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 ...