I have a question and I don't know if it's possible to configure in SQL.
You have a ERP GUI screen, with SQL tables, and the user changed a value of a field.
In this printscreen the cost price. Then when the new value is < or > then 30% of the 'old' value a simple mail must be sent to a user. Let say firstname.lastname@example.org (we use Exchange as mail server)
So an example : TO user XXXX, Subject text, body text is enough.
Or when the calculation of some fields < or > is then another field.
Example : cost price + transport + packing cost - discount is < or > 40% off the sales price.
As an example :
Table : Articles
Field : costprice, sales price, packing, transport and discount
For me it's importent how to start. How to configure stuff like this.
And then I can find/search on the internet for more solutions.
But now I have no clue how to start / configure ?
I'm a very beginner in SQL.