Hello all

I am trying to create an asset tracking DB... I have 5 tables... I would like one of them to be the "master" table... What I mean is table "computers" has the field "monitor"... then there is a table "Monitors" that has an "assignedto" field... When someone changes "computers.monitor" to a different monitor I would like it to clear "monitors.assignedto" of the old monitor and place the "computers.asset_tag" value in the new "monitors.assignedto" field... need help please...