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

Defining Lookup Fields in CAML that pulls multiple fields

We have defined a number of lookup fields like so: <Field ID="{81A578F2-8022-4083-8683-7F9BF039C82A}" Name="NameLookup" DisplayName="Navn" ...
1
vote
1answer
667 views

content query web part with multi value lookup column

I am trying to work out how I can query a content type with a multi value lookup field using the content query web part. I know that natively this is not possible with ootb sharepoint 2010 however I ...
1
vote
1answer
953 views

Conditional Sum of Data in Another List

I have two lists 'Projects' and 'Tasks' where 'Tasks' are associated with 'Projects' with a lookup column. On the Projects list I would like to display the sum of all of the 'Actual Time' values (a ...
2
votes
2answers
246 views

Lookup List and return data from within a Form

OK, I'm beginning to despair at SharePoint...please help restore some faith :) Seems some very basic things are very hard to achieve? 1: I have data in an SQL database table. 78,000 rows, but I want ...
1
vote
1answer
491 views

Modifying XSL for multi lookup field

I'm trying to create custom XSLT for a multi lookup field, based on this article. When changing disable-output-escaping to yes I can see the html I want to modyify: <a ...
1
vote
1answer
86 views

Create a lookup column in a list to reference a column in a list on another site (SharePoint 2007)

Is this possible with an OOB solution: I have list A on Site A and List B on Site B (site B is NOT a subsite of site A). There is a column in list A on Site A that I need to use in list B on site B. ...
0
votes
0answers
271 views

“Linked Item” Lookup available in browser by not SPD2010?

When I create a Lookup site column in the Browser, this enables me to choose "linked to item"...which then means it pulls back all the related information. However, if I do the same in SPD 2010, ...
1
vote
1answer
390 views

Clear Multiselect Lookup

I am trying to add a button for my users to clear a multiselect lookup value using JQuery or Javascript. I have found some information about setting a default value on a single select lookup, but ...
0
votes
1answer
476 views

Change the source on a lookup column?

Is it possible to change the data source on a lookup column? I have the source set to list A but I want to change it to List B.
1
vote
0answers
106 views

Best way to create a list with hidden columns with Data pulling from InfoPath form

So I have been working on this for a little bit here is what I am trying to accomplish: Using OOTB SharePoint 2010 Functionality I want to create an HR Referral System. Basically an InfoPath Form ...
1
vote
0answers
465 views

How do I create a lookup field for a hyperlink field and display the URL?

Ok, so there are a zillion posts related to and circling around this question, but that do not actually answer it to my satisfaction. I have a regular, out of the box, list of type "Links". I have ...
0
votes
1answer
63 views

Is a list being used as a lookup for some web part in the site collection?

We're cleaning up our MOSS site collection in preparation for the migration to SP2010. As we work on the top root site of our site collection, we realize that some of these lists (often with invalid ...
1
vote
2answers
1k views

Retrieving a lookup Value from a List using jquery and REST

I would like to get the lookup Value from a List item depending on it's Title. My List is set up similar to the following example: ColumnA : a | b | c lookupB : 1 | 1 | 2 The jquery: function ...
1
vote
1answer
201 views

Document library forces check-in upon adding custom lookup column

SharePoint 2007 Team Site Add a Document Library with the Word 2003 template Add a new item, save, close document, no problems Add a (required) custom lookup field to the document library Add a new ...
2
votes
1answer
416 views

How to update metadata?

I have following code (didn't list the whole code) behind a button on a InfoPath Managed Form. and it works meaning I can submit data to a list. Now I have 2 controls on the form that is ...
1
vote
1answer
79 views

I need to have the data from a list in another site at the same level to be available as a lookup in sharepoint 2010

I have a parent team site (Services) that contains multiple sub sites. One of the sub Teamsites is Call Inventory Containing our Stock List. Another Teamsite is called Purchasing containing a purchase ...
0
votes
2answers
207 views

How Can I create simple database in list Sharepoint Fundation?

How I can create simple database for example vacation request in SP list? It will looks like that: I create probably two list. In first list is vacation days people and on the second list is vacation ...
1
vote
1answer
485 views

Is it possible in LINQ to SharePoint

I have a task to make a WSP, which should provide definitions of custom list and library, but not instances. List definition has a lookup column to library item <Field ...
1
vote
0answers
25 views

Is that possible to filter and display the lookup values? [duplicate]

Possible Duplicate: How to make a filtered lookup field I am using project list lookup field in task list, so my project have # of items, but i need to restrict some of the project like if ...
0
votes
2answers
1k views

SharePoint list to lookup contact or account from CRM 2011

I have a SharePoint site and I would like to be able to create a list of which one column will be linked to a customer account. I have seen products that sync data between CRM 2011 and SharePoint ...
1
vote
2answers
599 views

Simple SPQuery throws error

I am trying to pull populate a lookup field using a lookup value without the lookup ID. I am getting the error: "One or more field types are not installed properly. Go to the list settings page to ...
0
votes
1answer
256 views

Customize LookUp Field

Someone knows how to customize a LookUp field to make it look like it: http://www.codeproject.com/Articles/18929/An-OwnerDraw-ComboBox-with-CheckBoxes-in-the-Drop (Dropdown + Checkbox).
0
votes
1answer
222 views

Retain array value after postback in sharepoint list edit form

I have saved the values on the right side of multi-select lookup column in an array . When i click on "save" to save the form, the values are getting saved properly. But when i try to edit the form ...
3
votes
2answers
3k views

Lookup Column Values With and Without ID;# in SPD with DVWPs

I see this difference when I'm working with lists in Data View Web Parts and manipulating the values in XSL. Why do some Lookup column values look like '1;#text' and others just have the text? I've ...
0
votes
1answer
451 views

Why is the associated lookup field not on the dispform.aspx?

I have three lists: Events (calendar) Customer1 (custom list from scratch) Customer2 (custom list from template) When I added the lookup of Customer1's ID and added the associated field "Title," ...
0
votes
1answer
435 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
231 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
363 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 ...
2
votes
2answers
665 views

Invalid Look up Value . A look up field contains invalid data

I have a multi select Lookup column . I have to populate values to the lookup column from another column on a button click. I achieved it using below code but when i try to click ok/save it is ...
1
vote
2answers
597 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
1answer
130 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 ...
1
vote
2answers
1k views

Cascading Dropdown for Lookup with more than 20 items

I have implemented cascading dropdown using SPCascadingDropdown (SPServices) it was working for lookup with 19 items . When the items count became more than 20 , the lookup column is displayed as ...
0
votes
1answer
662 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
2answers
5k views

How to get multivalue lookup column items from sharepoint list to infopath?

I am on a project. I have a list that have 2 columns. One is the title, other is a multiple value look up column from another list. Everything is ok, working well. And call it ListA. BUT, i am ...
0
votes
1answer
2k 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
149 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 ...
1
vote
1answer
528 views

Extending Content Types from Content Type Hub

I have defined a content type in content type hub. I would like to use this content type on a site (other than the hub) but also to extend it with an additional (lookup) column. Is it possible to do ...
0
votes
2answers
834 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). ...
6
votes
3answers
5k 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
510 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
269 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 ...
1
vote
0answers
316 views

CAML Contains on a lookup field of a calculated column

I have some issue when using the CAML Contains statement when the field is a lookup field on a calculated column. It basically does not work, the Equal works though. here is the query, nothing ...
4
votes
4answers
4k views

Why is my column not shown under “Add a column to show each of these additional fields”?

In SP2010, I want to get 2 columns from another list and merge these columns. But when I am trying to do this via Lookup, they are not shown under "Add a column to show each of these additional ...
1
vote
1answer
1k views

set multiselect lookup column using jquery

I have a Multi select Look up column which as you all know is a control with two list boxes and "Add or Remove" Buttons. The user populates the right-hand side of the control with some values by ...
0
votes
2answers
1k 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
1answer
721 views

Lookup column of type “User” showing #ERR

I've defined two list definitions and instances in a feature in VS2010. One list only contains a required field "Employee" which is of type User. The second list has two fields, a simple text field ...
1
vote
0answers
77 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 ...
4
votes
3answers
4k views

Deploying List Instance - LookupMulti Type Column in XML

So I have been able to populate rows with Lookup type fields as such: <ListInstance ... > <Data> <Rows> <Row> <Field ...
1
vote
2answers
2k views

Modify existing lookup type column to managed metadata type

We are in process of migrating one of our big website which is built in WSS 3.0 to SharePoint 2010 Standard version. In the process we want to convert all lookup columns to managed metadata type. We ...
1
vote
1answer
367 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 ...