Sharepoint List and Document Libraries

I have a document library that has lookup fields referenced back to a list. In the list there are duplicate values in the "Company Name" column (see below).

Progresso
Turner Industries
Progresso
Hooch Industrial

The problem I am having is when I edit a document in the document library and get to the "Company Name" lookup field I am seeing "Progresso" twice.  I have searched high and low to find a solution that would filter out the duplicate values and show just one.
LVL 2
Bryan PiggAsked:
Who is Participating?
 
theruckConnect With a Mentor Commented:
because if you feed it from a library then every record is unique as it is record id based not name based as in a list. then try to look for how to create a list out of document library  http://www.sharepointdotnet.com/2011/12/what-are-basic-difference-between-list_06.html
http://msdn.microsoft.com/en-us/library/dd490727(v=office.12).aspx
0
 
theruckCommented:
solve the duplicates in the company name column first or do not feed the value company name from the list and use another clean list instead
0
 
Bryan PiggAuthor Commented:
This is easily done if the column was in a list.  You simply use Infopath to edit the form.  Edit the drop down box properties and check "Show only entries with unique display names".  Why is the same functionality so hard to achieve in a document library edit form?

theruck thank you for your response but I feel that is a long way around to get to the solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.