update check boxes

[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

 

[Kevin @ 3NF]

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