update check boxes

  • Thread starter Thread starter alicia
  • Start date Start date
A

alicia

i have two tables joined with a 1-1 relationship.

they are 'logged in equipment' and 'logged out equipment',
with an 'equipment id number' in common.

when the equipment is logged out, a check box in 'logged
out equipment' table is automatically ticked, (with
default value =yes).

i have a logged out check box in my 'logged in equipment'
table, and i want this to be updated everytime a piece of
equipment with the same 'equipment id no' is logged out.

any suggestions?
thanks

alicia
 
Combine the tables into one Equipment table and have a Status field, with In
and Out being the only two choices.
 
Back
Top