Validation , do not allow data already registered

[mauriello72]

hallo

i would like to do a code register form. That code shoul be recorded only once , so that if the field "code" in the database already contain that code the user will have answer something like
"this code is already registered"

Any suggestion on how to do it?

Thank you