duplicate records

[Salisha Khan]

i am creating a form and the fields of the form are bound to the table. The
form will be use to enter employee records. If an employee is already
entered into the database, i want a pop up box that alerts the user that
employee is aleady in database, then i want some kinda of refresh function
or something to clear the fields and start entering another employee. See
what happens is when i enter an employee in the database that is already
there, then it fills in the rest of the information from the tables, and if
i go to delete it, it deletes it from the table itself since they are bound.
I hope this makes sense to someone, and i would totally welcome any
suggestions.
Thanks in advance.
salisha

 

[Janet Russell]

If you use the social security number, or some other
unique, employee number as the primary key field, the
program itself will pop up a message and not allow
duplicate entry.

 

[Salisha Khan]

thanks very much for the help