I have a database with a primary key(Employee id).
I am having an insert form, display form, delete form and main page form.
I want to validate the Employee id entered by the user in the insert form that means I want to check with the database, If it is already there in the database. I want to give an alert message when I try to submit the form.
How can I check the duplicate entry for Employee id while submitting the form?