Integrities

In case you want to automatically delete children items when a parent item is suppressed, you need to define the integrity parameter.
Open the properties of the children Foreign Key, and choose your prefered option.

N:M Foreign Key Integrity Cook

The integrities are infinitely cascadable.



Many to Many

If you are using many-to-many relations in your component, you need to set this option for both foreign keys. (Most cases)

For every foreign key in the Pivot table, choose 'FK integrity' = 'cascad' in the field properties.
(The previous image is giving the example)

Great UX great performance and definitely a time saver. It only took me 10 minutes of playing around before purchasing a subscription and right now I just want to throw more money at you! I just started a new project and after just 4h I can already tell it probably saved me several days of work. I'm building a wholesale ordering system with sales rep management. I have not looked at the code yet but so far: impressive.
flip (Forum)

Get Started