Specifying AND or OR

Within the Insert into and Delete from event classes, you can define multiple insert and delete events by specifying multiple tables. Similarly, you can define multiple Update of events by specifying multiple table names.

Using the Delete from event class disables row-based triggering. However, you can still define multiple Insert Into and Update of events using row-based triggering.

When you specify multiple table names within an event class, you must also specify how you want the condition within the event class to be met-either when all of the events occur for all of the specified tables or when one event occurs on any one entry in the list.

The options that dictate the condition(s) to be met when you set up multiple events are:

Option

Description

AND

This option dictates that all of the specified events must occur (for example, TableA AND TableB) for the condition to be met.

OR

This option dictates that conditions are met when at least one event occurs (for example, TableA OR TableB).