Loading...

Drop-down for Lookup column does not display unique values only

Title

Drop-down for Lookup column does not display unique values only

Description

Please wait...

A Quest List Form is being used to create a new list item in a site.
A lookup column has been created to bring in the values for a particular column (Company, for example)
from a list. Sometimes, in the drop-down for the lookup column the same Company name can show
more than once. How can the drop-down list only display unique values?

Cause

Internally, the lookup field works by using the ID, not the displayed text.

Resolution

WORKAROUND 1
Create a company list and store unique company names here. This is the list that needs to be the lookup field.

WORKAROUND 2
Create a custom field that will display the unique company name from the current list. A suggestion is to use  the company name as the key and ignore the key. That means, do not use a lookup field but simply use a single line of text field as the parent field.  
This approach requires version 4.3  to work.

Defect ID

Internally, the lookup field works by using the ID, not the displayed text.

Leave a Reply