title: Changing the value of a SQL table with inserts into an other table
body: <p>For example:</p>
  
  <ol>
  <li>Table: <code>Bankaccount</code>, with an <code>id</code> as primary key and a value.</li>
  <li>Table: <code>Category</code>, with an <code>id</code> as primary key, a name and a type (boolean, 0 for positive transactions and 1 for negative)</li>
  <li>Table: <code>Transaction</code>, with an <code>id</code> as primary key, a value (for example -10000$ for shopping) and a foreign key which references <code>Category</code>.</li>
  </ol>
  
  <p>My question is if it's possible to add some transactions to the <code>Transaction</code> table, which causes the automatic change of the value in the <code>Bankaccount</code> table.</p>
  
  <p>I hope someone of you could help me there!</p>