SharePoint Stack Exchange
SharePoint Stack Exchange

Questions tagged [lookup-column]

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

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

You can create relationships between lists by using a combination of unique columns, lookup columns, and relationship enforcement (cascade and restrict delete), all of which enhance your ability to create more sophisticated business solutions and help preserve the integrity of your data.

You can read more about lookup columns, here.

1169 questions
5
votes
2 answers

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 a webpart to display a list of child items at the…
David Culp
  • 1,309
  • 2
  • 11
  • 23
4
votes
1 answer

Filtered lookup column with 'WHERE' clause

I have 2 lists: List 1 and List 2. List 1 has 2 columns 'supplier' and 'broker'. List 2 has 2 columns 'nature' and 'supplier name'. My requirement is 'supplier' is a lookup from 'supplier name' column of 'List 2' where 'nature="supplier"' and…
Deepika
  • 43
  • 2
4
votes
2 answers

Create a lookup field that is text instead of a drop-down (or similar)?

In SharePoint, I have a list (staff) and a document library and have successfully made a custom lookup column/field from the document library pointing to the staff list (staff id column). This works ok, I now see a drop down showing me the…
Scott Szretter
3
votes
3 answers

Dropdown options are displayed in the wrong place. (IE only)

I am using SP2010. In one of the lists I have several lookup fields as dropdowns in the forms, and I have a weird issue: 3 of 4 dropdowns, which are rendered as input (>20 items) are opened in a wrong location after opening one of the dropdowns in…
user2633360
  • 131
  • 1
  • 3
3
votes
1 answer

How to sort SharePoint 2010 lookup combobox?

I have a lookup combobox whose source is another SharePoint list. By default, this combobox items are sorted by word order but I want to sort this items with another/custom order. How can I do this? Such as the default view of this combobox is: EUR …
newbie
  • 1,737
  • 2
  • 19
  • 35
3
votes
2 answers

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 items, and assign unique quantities to each…
Brenton Pierce
  • 193
  • 8
  • 21
3
votes
3 answers

How to populate Title column with name column content

In a doc library, the Title column is blank but the Name column contains the filename of the document uploaded. I want to concatenate (?) the Title column to auto fill-in what the Name column contains. Is there a simple calculated formula to use? My…
Paul
  • 41
  • 1
  • 2
3
votes
2 answers

A "throttling" exception for a lookup field

I have a large list (with item count > 5000) with invoice positions, which I want to be filtered by a lookup field (invoice header ID). I tried to filter the list extending the URL, i.e.: ...FilterField1=InvoiceID&FilterValue1=185 I made a view…
MKozlik
  • 31
  • 1
2
votes
0 answers

Getting distinct/unical values from External List

I have got an External List. I want to get distinct values from this External list to the dropdownlist getting from lookup Field. The values are often repeated. How can I get distinct values from Lookup Field in this External List?
Grzegorz Z
  • 1,709
  • 7
  • 42
  • 73
2
votes
2 answers

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 throwing error "Invalid Lookup Value" . Please help.…
user9167
  • 335
  • 1
  • 4
  • 12
2
votes
0 answers

Solution deployed to a web application errors when not using FQDN

EDIT: using SP2010, with Enterprise and Publishing features enabled at the WebApp and site where intend to use the feature. We have a 3rd party solution (Lookup with Picker [ilovesharpoint.fields.lookupfieldwitrhpciker.wsp]) deployed to a single web…
Bret
  • 66
  • 3
2
votes
2 answers

how to display another field in a lookup column dropdown?

In MyList I have a lookup column that is populated with values from a list with columns ID,DESCRIPTION When a user inserts a new item the dropdown box only shows ID values. I would like to see the DESCRIPTION instead as a user can't remember every…
Gyonder
  • 1,183
  • 3
  • 28
  • 49
2
votes
1 answer

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:
Michal
  • 863
  • 1
  • 9
  • 15
1
vote
2 answers

Multi Level Lookup in SharePoint 2010?

I would like to achieve multi level lookup as below Cluster List structure Project List structure Project List Entries Phase List structure When I select the cluster, it should show only the projects under the cluster but not all the…
Karthikeyan
  • 2,548
  • 14
  • 82
  • 142
1
vote
2 answers

SharePoint Best practice for multiple images per list item

I have to create a simple Classifieds system in SharePoint. One classified item can have multiple images. Does anyone have suggestions on design for this initiative? For example, should I have a custom list (Classifieds) which will contain a lookup…
Michael Colbs
  • 3,919
  • 2
  • 48
  • 96
1
2 3 4 5