?
Solved

SharePoint list unique records

Posted on 2011-03-25
1
Medium Priority
?
612 Views
Last Modified: 2012-05-11
In my Sharepoint list I have a field called ID...   Is there a way to make sure that duplicated records with the same ID can not be added?
0
Comment
Question by:Matt Pinkston
[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
1 Comment
 
LVL 6

Accepted Solution

by:
Rafael I earned 2000 total points
ID: 35225576
There should already be a field that is used internally by SharePoint called ID.  This field is unique, uneditable, and is never duplicated.  It is also usually hidden from the user.  If you click on a list item to view it, you will notice in the address bar it says something like, "..\DispForm.aspx?ID=2"

If you want to display it on your EditForm and DispForm, you need to either get SharePoint Designer 2007 to customize the form (easy), or create a content query webpart to load it into the page using JavaScript (hard).

Other than that, it is very hard to create a field that will prevent duplicate entries because you would have to manually query your list, and see if your new record's field matches an existing one (Hard/Complicated).
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

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.

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.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
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…

762 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