In this article we will be seeing how to enforce unique value for a list or library column in SharePoint 2010. In SharePoint 2010 we can enforce uniqueness on values in a list or library column, effectively creating a primary key. When you create a column in the list or library you could see an option "Enforce Unique Values" where you can enforce uniqueness. When you enforce uniqueness on a Lookup column, the list item in the target list can have only one list item looking up to it from the child list. Supported Column Types
Unsupported Column Types
I have created one list "cl" which has "Title", "TestCol" and "LookUp Col".
When you make Enforce Unique values to "Yes", you will be getting the following pop up.
I have enforced unique values to "Yes" for TestCol (Single Line of text) and LookUp Col. The items in the list are shown in the following When I try to add the same value, I was getting the following error Note: Comparison is case-insensitive, so the values "Test" and "test" are evaluated as equivalent.
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: