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
1answer
367 views

Why is edit item greyed out on lookup link

This is SharePoint 2010 Enterprise. This is all OOB stuff. I have one DocLib and two Lists. DocLib 1, List A, List B. DocLib 1 has two lookup columns. One to list A and one to list B. I have values ...
0
votes
1answer
135 views

How do i declare array for the lookup column using jquery

How do i declare array for the lookup column using jquery. I have a column whose values should be declared as array. so that my requirements get it complete. I need that ID for every values to get ...
0
votes
1answer
445 views

Access Lookup to Linked List

I am trying to create a lookup from one Access table to a linked list from SharePoint. I need to have a lookup between the two because in order to create the type of subform that I need, there has to ...
0
votes
1answer
222 views

Lookup fields blank after dialogue

I have a problem on a SharePoint 2010 site. I have lists which contain Lookup fields. When I perform any action on the site that causes a custom dialogue to be displayed, the lookup fields become ...
0
votes
3answers
3k views

Displaying value in infopath not the number

Infopath. In my infopath form. I want to show the teamName as "team 1" value but it is displaying "1" number instead of "team 1". The TeamName is a lookup column in the ProjectList.
0
votes
1answer
1k views

Editing rendering of Lookup Field - XLST

Let's say I have a simple text column named MyCustomName with four fields in it: REMOVE one REMOVE two three REMOVE four ...and I want them to display like one two three four in my list View. In ...
0
votes
1answer
84 views

Cross site cross database lookup field SP2010

SiteCollection 1 in ContentDB 1 has List 1 with custom lookup field. This lookup field returns all text fields from any selected list in a site collection specified. Each site collection is in a ...
0
votes
1answer
33 views

quick way to access splistitem in different list?

I have 2 lists: listA and listB listA has 2 fields: Title (text) PortalID (text) listB has 3 fields: Title (text), listAField(lookup to listA Title field) UserID (text) I have a UserID value ...
0
votes
1answer
455 views

Restricting number of selections on a multiple lookup column

How can I restrict the number of values a user can select from a lookup column? It doesn't seem to have the same column validation settings as some of the other column types. I only want a user to be ...
0
votes
1answer
103 views

Possible to lookup a Sharepoint list in Access?

I am trying to make a very large list of records with about 1,000 items or more added monthly, and I was told that it would be better to use an Access table instead of a Sharepoint list for so many ...
0
votes
1answer
350 views

Adding the other fields in addtional to lookup field in CAML

I have a custom field definition in VS2010 that contains a lookup field (Title). All is well and I can use the Title ref to add items in the SharePoint list UI. in the instance UI, I can also check ...
0
votes
1answer
41 views

Is there any programmatic way to determine if a list has any relationships to other lists?

If list A has a SPFieldLookup to list B is there any thing in list B's SPList object to show the relationship with list A? While I can flip through list A's fields and find the relationship to List B ...
0
votes
1answer
165 views

Can I edit a LOOKUP column?

More concisely: How do I edit a lookup column? I have a custom list with columns [Name] and [Product] named 'MainList'. I would like a third column [Referral] which shows a name found in ...
0
votes
1answer
31 views

Checking if a list is consuming lookup value column or not

I have two lists, List A [Document Number, Name, Title,...] (document library) List B [Information Number, Name, Title, Document Number] (simple list) Now List B is getting all documents from List ...
0
votes
1answer
669 views

Using additional fields from Lookup in Word Document Information Panel

I have a Document Library in which I have a lookup columns to a Contact list, the contact list also includes linked values as email, phone numbers and so on. When creating a new word document in ...
0
votes
1answer
419 views

How can I make a filtered lookup view that doesn't remove the value in it as I delete items from the lookup list

I have a list of Projects. As they are completed I want to delete the item (or tag it as completed). The Project Library looks up "Project Name" from the list of Projects (so that it is easy to find ...
0
votes
1answer
1k views

List as a look up value from another site

I would like to use a list from one site as a look up for another site. Can I do this with out using code. Only use OOTB or Designer? Or is there a better way?
0
votes
0answers
349 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, ...
0
votes
1answer
116 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 ...
0
votes
2answers
2k 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 ...
0
votes
1answer
499 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
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). ...
0
votes
1answer
2k 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); ...
0
votes
1answer
895 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 ...
0
votes
0answers
1k 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 ...
0
votes
1answer
414 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
0answers
247 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
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
3answers
964 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 ...
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
859 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
1answer
25 views

Content Types Template problem with lookup column in template

I have a content type. When I want to create a new document from that content type the properties (Columns) for that content type also open in my document. The problem is that there is one lookup ...