Cascade Update Related Fields This check box is for those Access users who use actual data to link two tables.You should only need to check this on the rare occasion when the ID field is an internally generated integer.When this box is checked, Microsoft Access will automatically delete the associated child records.All relational database management systems have this automatic capability option.To make sure that you can take advantage of any new capabilities, update your grant tables to have the current structure whenever you upgrade My SQL.See Section 4.4.5, “ The following sections provide general descriptions of the static and dynamic privileges available in My SQL.
It should be used to maintain the integrity of the relations in your database.
In the diagram (above) there is a parent/child relationship between Author and Books. Enforce Referential Integrity When creating the link you will want to mark the 'Enforce Referential Integrity' check box and the 'Cascade Delete Related Records'.
By checking the ‘Enforce Referential Integrity’ setting, the insertion of 'orphaned' records is prevented.
Access-control decisions are based on the in-memory copies of the grant tables.
Some My SQL releases introduce changes to the structure of the grant tables to add new privileges or features.