Preventing duplicate entries. (1 Viewer)

[Radion]

Hi again, thanks to all for the help given so far.

Is there anyway (other than making that field a primary key) to prevent the same value being entered into a different record?

E.g.

If under 'Name' Radion has already been written, I want an error message coming up saying there is already a record with radion.

 

[Radion]

Ok, figured it out. Lol, I should get slapped on the wrist for that!

 

[Radion]

Ok, I've prevented Duplicates. How do I put in a customized message saying "There already exists a Radion"?

 

[Graham T]

Radion

This example might be along the lines of what you are after, although you will need to be entering your data via a form, not directly into the table (which is what you should be doing anyway):

Preventing Duplicates from being entered

HTH

Graham