referential integrity

even having checked the option referential integrity, cascade delete and cascade update… when deleting a record in the master table, the details are not deleted. Is anyone else having this problem?

You may enable Debug and check the SQL executed and errors in the log file. Note that if there are errors, the transaction will be rollbacked.