Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011

    Unanswered: Automatically calculate values in one table based on data in another.

    I am creating an example database for a coffee shop. In the item table I have item name and item price. in order line item table I have quantity item price and extended price (quantity times price)
    and in the sales order table i have subtotal, tax and total.

    how do i have the database automatically insert item price in the order line item table and then calculate extended price. then take extended price from order line item and insert in subtotal of sales order table and the compute tax and total? or do i need to do this all by hand?

  2. #2
    Join Date
    Nov 2006
    Use triggers.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts