title: Calculate Equation From Seperate Tables Data
body: <p>I'm working on my senior High School Project and am reaching out to the community for help! (As my teacher doesn't know the answer to my question).</p>
  
  <p>I have a simple "Products" table as shown below:</p>
  
  <p><img src="https://i.stack.imgur.com/gYjpV.png" alt="Products table image"></p>
  
  <p>I also have a "Orders" table shown below:</p>
  
  <p><img src="https://i.stack.imgur.com/4llO5.png" alt="Orders table image"></p>
  
  <p><strong>Is there a way I can create a field in the "Orders" table named "Total Cost", and make that automaticly calculate the total cost from all the products selected?</strong></p>