value, if already exists

[deepbreath]

if a user enter a value in a field, can we check that this value already exists in database and if yes then msg that this value already exists and ask wether you want to see it and if yes takes you to the previous record. thanks

 

[deepbreath]

any suggestions plz