asked on 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.
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.
Microsoft SharePoint
Last Comment
theruck
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
ASKER
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.
theruck thank you for your response but I feel that is a long way around to get to the solution.
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionYour help has saved me hundreds of hours of internet surfing.
fblack61