Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Distinct Rows in Look up Field on SharePoint List

  Asked By: Jean    Date: May 02    Category: Sharepoint    Views: 5469

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?



1 Answer Found

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

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.