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?
Title
Drop-down for Lookup column does not display unique values onlyDescription
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.