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)

Really great Joomla tool Cook is a great piece of kit for creating Joomla components. It uses a drag-n-drop interface to build tables and fully featured pages. You can test your component in a sandbox before downloading it packaged up ready to install. The developer is responsive on the support forum.
Twev (JED)
          

Get Started