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

null