Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Distinct Rows in Look up Field on SharePoint List

  Asked By: Jean French         Date: May 02, 2009      Category: Sharepoint      Views: 941
 

I have a list that uses a look-up field from another SharePoint list on
the same site; my problem is that the source list can have multiple
entries with the same name. I want to be able to limit what shows up in
the destination look-up field, so that only distinct names show up in my
lookup field. Is this possible?

Tagged:                  

 

1 Answer Found

 
Answer #1       Answered By: Erick Carlson          Answered On: May 02, 2009       

No you can't - at least not with the out-of-the-box lookup fields. If you
have no other alternative, you can create your own custom field  type to do
this.As a developer, I would recommend learning how to create custom
field types - it saved my hide several times.
 
FYI - Under the covers, the listitem with the lookup stores the ID and
description of the lookup item (delimited by ;#)For example, it
would store 3;#ItemDescription.In this example, 3 is the ID value for the
lookup listitem and ItemDescription is the text display value for this listitem.

The way SharePoint stores this value allows you to change the descriptions in
the lookup list  without impacting the listitems that reference it.

 
Didn't find what you were looking for? Find more on Distinct Rows in Look up Field on SharePoint List Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].