In SharePoint 2007, we couldn't
set unique enforcements to each column or fields to avoid duplicate values in a
list or library. "ID" is the only
one having unique constraint in SharePoint 2007.
Before to know about enforce uniqueness
feature better to get an idea on how can we handle the duplications on list
items in SharePoint 2007.
How can we set the enforce uniqueness to the
columns in SharePoint 2007:
Best way to achieve enforce uniqueness
to the columns in SharePoint 2007 is event handler. We can handle it by
comparing the column values in ItemAdding event.
SharePoint came up with the enforce
uniqueness feature. We can handle the enforce uniqueness easily through UI only
for the newly created columns.
