Software and Applications (non-game)
Synonyms and Antonyms
Microsoft Access

What are the ways of preventing duplicate values in a field?

User Avatar
Wiki User
February 13, 2005 3:15AM

Vague question, but if you are talking about a database field,

the simple way is to create a unique index on the field (if the

database supports it). The index will not allow duplicate values to

be added to the database for that field and will generate an error

if somebody tries.

Copyright © 2020 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.