It sounds like you should use TRIGGERS for this. Also, as described, everything is really controlled by level 1.
You can learn about triggers for AFTER (INSERT, UPDATE) Here are some sources which you can pick through to determine which one you can learn from most easily:
Google[
^]