I have a table 1, with fields called division, section, room among other fields. I have a table 2 with fields also called division, section, room. I want to update those fields in table 1, whenever i add values to table 2. That requires updating 2 tables at the same time. How can that be done?
use the row_inserted or row_inserting events