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

learn more… | top users | synonyms (1)

0
votes
1answer
488 views

Read lookup value dynamically from list and fill select box

I have one list with different musical Genres, this list is linked as a lookup to the lists Bands and Records. When I register a new band I set the typical genres played by this band and when ...
1
vote
0answers
285 views

How to get lookup field text column to display as an image in a view?

Wonder if anyone can help. I want to add a category choice field to a SP2010 Announcements list. The category choice is a lookup field to another list. The other list contains the categories and a ...
2
votes
1answer
483 views

How to improve performance of lists with multi-lookups

I have a list that includes several lookup fields. Some of these are simple lookups (only one value allowed), others are multi-lookups (the "allow multiple values" checkbox is selected). I have ...
1
vote
2answers
716 views

Add lookup field to list from a RootWeb

I have the site collection rootweb called Main Site. I have many subsites called according to the year, 2012, 2011, etc. In the rootweb, there is a list called Products. In the subsites there is a ...
1
vote
2answers
4k views

Sharepoint 2010 and Infopath form : lookup fields are displayed by their ID instead of text value

I'm trying to build a custom Infopath form for a list that contains 2 fields that I would like to get auto-completed: Person: people picker field, filled with the current user Team: lookup to the ...
1
vote
1answer
161 views

Why do some of my lookup fields have type-ahead in the UI?

(And how can I get all of my lookup fields to have type ahead?) So here is the weird thing: I have several lists and lookups which I am deploying as a part of a .wsp. Of all of the lookups that are ...
0
votes
1answer
786 views

Sharepoint 2007 lookup column

I have a site dropdown column using a list as the datasource (lookup). I was looking for a way to have the column be both required and have a default blank value. I read that is is not possible ...
1
vote
1answer
3k views

CAML query for null lookup field values

I have a problem with filtering list items using CALM I Have this list: Code - Text, Name - Text, Link - Text, Order No - Number, Parent - Lookup to this List. I want to filter all items where Parent ...
0
votes
1answer
190 views

List to library lookup

I have a list which contains information about pieces of equipment. I also have a document library which contains things like certificates, receipts etc which relate to the equipment. In the list I ...
0
votes
2answers
1k views

Retrieve Selected Text from Multi select LookupColumn with more than 20 items

I have a lookup column with more than 20 items and I want to retrieve the selected text in a variable.To achieve this I have tried the code below but I am getting an error(mentioned in the code). ...
7
votes
3answers
6k views

How to get the ID of the list item just inserted using ecmascript

I am stuck at a place where I have to update a list which has a Lookup column. For example I am using this code to update my normal list var clientContext = SP.ClientContext.get_current(); ...
0
votes
2answers
645 views

Lookup field on custom form does not save once deployed on testing

I have a custom form on a content type I've created. This content type has 3 site columns which are a lookup field from 3 lists. In the form I've created the user selects a dropdown box and chooses an ...
0
votes
2answers
308 views

How to group repetitive items?

I have 1 list and 4 field in it. one column is person, one is title, one is feature, one is experience. all columns are look up except title. But i have problem with person. If i want to add ...
0
votes
2answers
2k views

Multi select Lookup column returns null in javascript client object mode;

I am trying to retrieve the selected values of multi select lookup column and store them in array and then set the lookup column with the same selected values after drop down value changes but always ...
1
vote
0answers
87 views

Lookup columns into document template

I've a DocLib with the lookup field Field01 and I want to display the associated lookup columns as Field01:FieldA, Field01:FieldB... I already have them on the view, now I want the exact same ...
0
votes
1answer
657 views

How to use the Links list item as target column for a lookup field in SharePoint?

I have created a Links list in my SharePoint 2010 site. Also, I have created a default document library. Now I want to create a new column in the document library; the column should be a multiple ...
1
vote
1answer
420 views

Calculated column based on data in linked list in Sharepoint 2010

I have two sharepoint lists: one with all budget positions one with all cost centers the budget positions have a lookup column that links to an entry in the cost center list. What I would like to ...
1
vote
0answers
124 views

How do I create a linked keyword index?

We have a 2000-document library that we use as a knowledge base. We're trying to create a hyperlinked index of keywords. In this simplified example, consider the following metadata for a document ...
0
votes
1answer
3k views

How do I update a lookup column from a dropdownlist?

I'm creating a custom web part in asp.net for SharePoint 2010 programmatically. When a user presses an Add button, the selected item from the dropdownlist is supposed to then be added to the Groups ...
1
vote
1answer
775 views

Lookup with a custom field type as target

I want to create a lookup field with the sharepoint ui which points to a field with a custom field type (parent field type is number). In visual studio with the object model this is not a problem but ...
0
votes
1answer
1k views

SPLookUpField and Adding Values

I am creating a custom list programmatically. List has one Lookup field. Here is my code sample how I am creating LookUp field. oList.Fields.AddLookup("Parent", oListGuid, false); ...
1
vote
2answers
130 views

Document look-up of PDFs

I have a look-up to the Documents list on the Title column, containing a mixture of DOCX and PDF files. The DOCX files appear in the drop-down, but the PDFs seem to be ignored. I can open the PDF ...
3
votes
1answer
3k views

Maximum allowed values in a single sharepoint lookup column/ sharepoint list update

I am facing problem with my custom developed webpart which inserts data into a sharepoint list using excel sheet. I have a list with around 50+ columns in it, it has 10+ lookup columns in it, things ...
2
votes
0answers
322 views

Multivalue and single value lookup issue

Let's assume that we have two lists - Foo which has some kind of information - no matter what, and second - Cities - which holds city names. Now, we set up on Foo list lookup field to City list and ...
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 ...
1
vote
3answers
3k 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 ...
0
votes
0answers
775 views

Lookup multiple-values on form-library sharepoint 2010 for InfoPath Form

I use InfoPath form template for a form library without coding. I want to get multiple-value of lookup to another list items. For lookup I should use sharepoint 2010 column due to no such data type in ...
4
votes
2answers
7k views

How to retrieve lookup values using ClientContext?

What's the best way to retrieve lookup values using ClientContext? I'm accessing a list using ClientContext (let's call it ParentList). That list contains several lookup fields (let's call one of them ...
3
votes
1answer
561 views

AddLookup using the client object model?

Trying (desperately) to find the Microsoft.Sharepoint.Client equivalent of SPList.Fields.Addlookup My code: ClientContext ctx = new ClientContext("http://sharepoint/"); Web website = ctx.Web; ...
1
vote
1answer
677 views

Add lookup field with object model?

I have an existing list "Country List", Column "COUNTRY" contains name of the all the countries. I would like to create a look up field "Origin Country" in a list "Order List" via OM. How do I do ...
0
votes
2answers
293 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 ...
2
votes
3answers
2k views

Can someone provide examples and direction with relational list?

I'm trying to figure out the best course of action concerning relational lists. I have create several parent and child related lists but I'm having a bit of trouble understanding how to build my CAML ...
0
votes
1answer
313 views

Showing referencing items in list view

I need to create a list view in SharePoint where several foreign Items which are referencing the the actual item are beeing displayed. As example the actual list is called companies and for each ...
4
votes
2answers
4k 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
4answers
4k views

Two-Way Relational List

We are testing SharePoint 2010 Standard and have a need to have relational data, but be able to view the data from both sides of the relation. For example, I have a contacts list and I create a list ...
5
votes
2answers
151 views

Strategy Queston : how would you implement this calendaring use-case

At my organization there is a process that goes in to preparing for our Board of Director's Meetings that begins 6 weeks beforehand and involves about 9 different steps. We have a template document ...
1
vote
3answers
6k 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 ...
0
votes
1answer
351 views

Copy data from Lookup field to Filtered Lookup

I'm migrating a list up a level from the site to the site collection. After migrating the list via list template, I need to move the data from the Lookup to the new Filtered lookup field on the same ...
0
votes
1answer
926 views

How to pre-fill the look-up column in a child list?

How to pre-fill the look-up column in a child list item based on the parent item, from whose form the child is being created? Is this possible?
0
votes
1answer
785 views

Filtered lookup field

I would like to apply filtering to existing out-of-the-box lookup fields (without InfoPath). The solution should be limited to GUI only: when Backup/Restoring to a clean farm the filtering would be ...
2
votes
1answer
7k views

How can I pass a Parameter via Query String to populate a lookup field on a New Item Form/DVWP?

I have two lists: List A: Products List B: Requirements I'd like to have a nice Create Requirement page launched from the Product Listing page. I have a DVWP/Multi-Item View displaying all ...
7
votes
3answers
2k 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" ...
2
votes
2answers
761 views

How do I create custom control or action that works in a list's DataSheet view?

I have created a cascading lookup column field for a list in sharepoint 2010. It's working fine in the Standard view but not in the DataSheet view. In datasheet view it is showing all the possible ...
0
votes
0answers
197 views

How to retain permissions for a user in Lookup field?

I have column level permission using a custom code. But I am unable to retain permissions for a user in Lookup field! Is there a way to do it?
0
votes
3answers
8k views

Add values to lookupmulti field in c#

I want to add values to a lookupmulti field with c#. the form shows the field correctly but my code just won't work: SPList list = SPContext.Current.Web.Lists["testlist"]; SPListItem item = ...
0
votes
3answers
8k 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 ...
0
votes
1answer
874 views

Lookupfields not showing up in customlist sharepoint 2010

I have a custom list on dev-int environment, now I saved it as a template and moved it over to the dev-vm environment and created a list (Listl1) based on the template. Now this list consists of few ...
1
vote
0answers
298 views

Content Organizer rule based on a Lookup Column with more than 20 selectable values

Does anybody have any experience making content organizer rule based on a Lookup column with more than 20 values in the list? (When you have more than 20 values, the view of the Lookup field changes. ...
1
vote
0answers
458 views

How to take a value from a single line of text field in one list and set it as a lookup field in another list?

I have SP 2010 and SPD 2010. I have list A that has a single line of text column named Res ID #. This provides the source for List B as a lookup column. I want to create a WF that will put the info ...
3
votes
2answers
330 views

Assign lookup list item with a quantity?

Parent List has a lookup with multiple promotional items. Once user chooses a promotional item, I want user to be able to add a quantity to that specific item. User should be able to select Multiple ...