A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.
3
votes
4answers
10k 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();
...
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 ...
0
votes
1answer
1k views
Pull values from a lookup column using SPServices()
I would like to retrieve values from a lookup column (pull down) using SPServices() and load an array in javascript. This is available only in Newform.aspx. How can I do this?
3
votes
3answers
1k 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 ...
2
votes
2answers
3k 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 ...
2
votes
1answer
964 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 ...
3
votes
1answer
1k views
Can you have lookup column to rich text field
Can a SharePoint 2010 lookup column point to a multi-line rich text field in another list? From what I'm reading, it can only see single-line text fields in the other list, which limits its use in our ...
2
votes
2answers
477 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 ...
2
votes
2answers
621 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
0answers
266 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 ...
1
vote
1answer
450 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 ...
1
vote
1answer
940 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 ...
1
vote
4answers
785 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
1answer
459 views
How to get count related Lookup value programmatically?
Another day, another question ;)
So, I have two custom Lists, "Attendees" and "Events". In the Events-List there's a Lookupfield "Registrations" which I want to fill programmatically on page_load. In ...
0
votes
2answers
231 views
How to add a from lookup field value to the text
I think about how to add a from lookup value to the text ? How can I write it to another colum ? In the same list.
0
votes
3answers
5k 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
2answers
269 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 ...
