Solved

Sharepoint List and Document Libraries

Posted on 2013-01-02
3
268 Views
Last Modified: 2013-09-25
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.
0
Comment
Question by:Bryan Pigg
[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
 
LVL 14

Expert Comment

by:theruck
ID: 38737662
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
 
LVL 2

Author Comment

by:Bryan Pigg
ID: 38737708
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
 
LVL 14

Accepted Solution

by:
theruck earned 500 total points
ID: 38737723
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question