CODEWITHSUNDEEP
sharepointduplicate-data
JL.
JL.

Reputation: 81342

SharePoint: How to have a unique constraint in a list?

In SQL its possible to have fields that cannot contain duplicate data.

How is this possible in SharePoint?

Lets say you have a list containing values like 

ORANGES
APPLES 
PEARS

How do you ensure that the user cannot enter

ORANGES
APPLES 
PEARS
ORANGES

Thanks

Upvotes: 3

Views: 4090

Answers (2)

Adam Butler
Adam Butler

Reputation: 3037

Looks like this can be done in 2010

If you go to your list settings and click on the column there is the option "Enforce unique values"

Upvotes: 3

Alex Angas
Alex Angas

Reputation: 60047

This can't be done out of the box. But there are these community solutions:

Upvotes: 2

Related Questions