OK a brief introduction to triggers and more importantly how I used them to overcome a formset limitation.
Triggers are events that get ‘triggered’ whenever a record in a database is updated or a new record is added to a table. From a Sage perspective it gives us control over changes made to the data and [...]

Continue reading " Database Triggers "

What is normalisation and why should you care? Normalisation is the removal of duplicate data across tables in database. You wouldn’t store a customers complete details against each purchase order, you would store the customer details in a separate table and link your purchase order table to it via a ‘key’. Now the Sage Line [...]

Continue reading " Normalisation "