Triggers

You can use triggers to carry out database actions whenever a record is added, edited or deleted.

For example, you could calculate the key used by an external application and enter this value in a field.

1. Click in the Trigger column to enter the SQL code for the database trigger.

   

2. Select the type of database you are defining the trigger for (MSSQL or Oracle).
3. Select New, Update or Delete to determine whether the trigger is initiated by adding, editing or deleting a record.
4. Enter the SQL statement in the Text field.
5. Click OK.