Making at least one record required.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an employee information form that has a yes/no checkbox for the
employee to be an administrator. There must always be at least 1
administrator or they will not be able to login to the options section(which
is where the employee form link is located). What would you put in the
beforeupdate section to not allow a user to save a record unless there is at
least 1 admin?

thanx
 
James,

This could not happen with a new employee record, right? This could
only happen if you are editing the record for an existing employee who
happens to be the only currently assigned Admin, and you remove the
admin status from this person. Do I understand correctly?
 
Correct. The database is started with an employee record called admin with
the admin check box = true. I want them to be able to delete the admin
record but only if one or more records has the admin check box = true.
 
Back
Top