Synchronizing two tables

poppins

Hi everyone,

I have two tables with the same primary key and many identical boolean fields(same id,same value).
I want that when I delete a record from table1, the boolean in table2 take all the value false.

Example:

record in table1: key=xxx, bool1=true bool2=true

record in table2: key=xxx, bool1=true bool2=true

If I delete the record in table1:

record in table2: key=xxx, bool1=false bool2=false

Is it possible?

lvanvugt

poppins wrote:

Is it possible?

Why not? Just before the record in table1 being deleted (so in the OnDelete trigger of table1) make sure to update the related record in table2.