0
Trigger in use
Our 3rd Invoice – With the New Price
Now, change the price for Champagne to €9 in the Food & Drinks table.
We change the price in the "Food & Drinks" table
Now, create another invoice. Again, with lots of champagne!
Result
Et voilà! All invoices now display the correct unit price at the time they were issued!
We create a 3rd invoice with the new price. The prices of previous invoices remain unchanged!
Want to explore this topic further? Check out the relevant section in our video tutorial.
Now, let's learn about Roles and Permissions. After all, not everyone should be able to tamper with your database!
Reply
Related articles
Content aside
- 22 hrs agoLast active
- 7Views
-
1
Following