title: How do you link a field in a table to the sum of a field in another table?
body: <p>Please I use Sql Server
  I have the Quantity field in the Items table equal to the sum of the Quantity fields in the Stocks table.
  Is there a way to do this automatically in?
  <a href="https://i.stack.imgur.com/qyCyt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qyCyt.png" alt="enter image description here" /></a></p>