Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
COURSE of the MONTH
10 days, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Sharepoint List and Document Libraries
Posted on 2013-01-02
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
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
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.
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
http://msdn.microsoft.com/en-us/library/dd490727(v=office.12).aspx
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
How to fix incompatible JVM issue while installing Eclipse
While installing Eclipse in windows, got one error like above and unable to proceed with the installation.
This video describes how to successfully install Eclipse.
How to solve incompa…
Suggested Courses
Course of the Month10 days, 14 hours left to enroll
770 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.