ACCESS trigger delete table event variable usage and continuous deletion_PHP tutorial

ACCESS trigger delete table event variable usage and continuous deletion

After the TABLE DELETE event of ACCESS is triggered, an [old] record will appear. This record is very useful and can Used for conditional judgment.

In the table event as shown below, after deleting a record, you can use the [old] record connection to perform multiple operations to delete related records.

One thing to note is that the FOR loops of the two deletion actions need to be at the same level!

It should be noted that the variable OldFTid at '1' can be used at '2'. The syntax is:

When condition = [ReviewData].[FTid]=OldFTid

Reference: