Solved

SharePoint list unique records

Posted on 2011-03-25
1
606 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
1 Comment
 
LVL 6

Accepted Solution

by:
Rafael I earned 500 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

837 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