Drop-down for Lookup column does not display unique values only
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?
<p>Internally, the lookup field works by using the ID, not the displayed text.</p>
<p><p>WORKAROUND 1<br/> Create a company list and store unique company names here. This is the list that needs to be the lookup field.</p><p>WORKAROUND 2<br/> 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. <br/> This approach requires version 4.3 to work.</p></p>
<p>Internally, the lookup field works by using the ID, not the displayed text.</p>
