duplicate records

  • Thread starter Thread starter Salisha Khan
  • Start date Start date
S

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
 
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.
 
Back
Top