Primary Key for Sharepoint list to prevent duplicates

  • Follow


I need to make sure that no duplicate records can be created in a SP list. If 
this were an Access table, I would simply make the field I want to prevent 
duplicates in the primary key.  The ID field in SP is auto-generated. How can 
I prevent duplicates in a non-ID field of a SP list?  

0
Reply Utf 5/20/2010 3:35:01 PM

1. Ribbon -> List Settings
2. Access column Settings for your non-ID Column.
3. Check the "Enforce Unique Values" box.

-RH

"bwjohnson1" wrote:

> I need to make sure that no duplicate records can be created in a SP list. If 
> this were an Access table, I would simply make the field I want to prevent 
> duplicates in the primary key.  The ID field in SP is auto-generated. How can 
> I prevent duplicates in a non-ID field of a SP list?  
> 
0
Reply Utf 6/1/2010 3:28:01 PM


That's just for Sharepoint 2010, right?

I don't recall ever seeing anthing to do this in prior versions.


--rms

www.rmschneider.com




On 01/06/10 16:28, Ryan Hamshire wrote:
> 1. Ribbon ->  List Settings
> 2. Access column Settings for your non-ID Column.
> 3. Check the "Enforce Unique Values" box.
>
> -RH
>
> "bwjohnson1" wrote:
>
>> I need to make sure that no duplicate records can be created in a SP list. If
>> this were an Access table, I would simply make the field I want to prevent
>> duplicates in the primary key.  The ID field in SP is auto-generated. How can
>> I prevent duplicates in a non-ID field of a SP list?
>>
0
Reply Rob 6/1/2010 5:27:57 PM

2 Replies
3019 Views

(page loaded in 0.053 seconds)

Similiar Articles:













8/1/2012 7:36:33 AM


Reply: