do i need to save order amount in orders table or i can calculate everytime from services table against each order ID?
Advertisement
Answer
Just create a view of the orders table joined with the services table with the calculation you want against each orderID?
If you want more details on how to do this then include the minimal data to help out:
Table names, column names, example data.
but if you know how to create views then this should suit your needs.