how do I create a trigger so that if a data is inputted in a certain table it automatically affects another table either by adding or subtracting?

Question

urgent

Answer 1

it has many techniques

relationship
and views to read multi tables

Answer 2

okay....please tell how to go about it?