IF select this unselect the other one?

[Krefty]

Good Day and thank you for looking at my problem. I have
a database that I use to keep track of employees whom are
on standby, or on call. A request has come from the users
to attempt to improve that if you select one of the
employees from a search/table(Combo Box)the user selects
the desired employee, it populates the form with all table
related data, phone, name and one of the following Office
Locations,
"Baker/Ontario/Nyssa";"Bend/Red/Prine/Mad"

3 are considered one location and the other 4 are
considered another location. Then the user chooses if the
employee is on any of the ITEMS listed below

"";"Service Standby";"Supervisor OnCall";"Back-
Up";"Sick";"Vacation";"Not Available";"Funeral";"General
Office"

My GOAL, the user would like IF they select "Service
Standby";"Supervisor OnCall" for a employee that any
employee that was already selected from the same Office
Location that it unchecks or deselects the former/previous
employee that was STANDBY or ONCALL.

Currently when Employee A from Baker/Ontario/Nyssa takes
STANDBY the user has to go and choose employee A and then
from Standby Status choose what kind of Standby they are
on, but then the user has to review the report and go back
and uncheck/select Employee X that was on STANDBY the day
previous. I desire once Employee A is selected with the
same office Location that the database removes Employee X
from Standby Status.

I hope that I was clear and as always thank you for
looking at my problem.

Krefty

 

[Douglas J. Steele]

Without knowing exactly how you're storing all this information, it's
difficult to give an exact solution, but essentially what you need to do is
run an UPDATE statement that changes the status of any employee WHERE
Location = <whatever> AND Status = <whatever> AND EmployeeID <> <new
employee's ID>

 

[Krefty]

I store the employees information including Office
Location in a table [Southern Employees] and the choices
for differant STANDBY in a Value List on the FORM. Thanks
for the help, if you were able to further assist it would
be greatly appreciated.