title: how to update the records from one table to another
body: <p>I have 2 tables:</p>
  
  <pre><code>1)NewAccount
  2)Deposit
  </code></pre>
  
  <p>NewAccount table contains fields as:</p>
  
  <p>1)accNum as primary key
  2)amount</p>
  
  <p>Deposit table contains fields as:</p>
  
  <pre><code>1)accNum as foreign key
  2)DepositAmount
  </code></pre>
  
  <p>My question is if I click on one button it should insert all values to the deposit table as well as it should add that amount to the amount field of NewAccount table.</p>
  
  <p>Here is an example:</p>
  
  <p>if amount field of NewAccount has 500.00
  if I add deposit amount of rs 400 .then amount should update to rs.900 in NewAccount table of amount field</p>