I've made some tables which I've defined correct referential integrities for. I've chosen Cascade to be able to delete an entire branch from the hierarchy, meaning if I delete the parent, all its children are also deleted.
This is where it gets problematic. If I try to dlete a parent with Delphi or in Database Desktop, i get the error message "Master has detail records. Cannot delete or modify". I've tried changing the Delete property for this in the Database Explorer, but get an error message saying something like "Cannot edit Delete operation".
How can this be done?