How to delete rows from tables that relate to other tables

[goedible]

I want to delete form this database all of the ‘plots’ that are not marked ‘public’.
When I try to delete a ‘plot’ from the ‘Plots’ form
I get this error:

SQL Status: 23504
Error code: -8

integrity constraint violation: foreign key no action; SYS_FK_10216 table: beds at ./connectivity/source/drivers/jdbc/Object.cxx:173

I think I have to tell it to also delete all of the beds and all of their plants associated to that plot. What/how can I do?

Here is a link to the database https://www.dropbox.com/scl/fo/h9kn7rdru9s7e20h1s1f8/AFQNeUMCKouLx093XxMdxfI?rlkey=31zcxffpml87tjqr3cils6vl3&st=zingyfq1&dl=0

[Wanderer]

Check the following thread/link. You may need a “cascading” delete in your relations.

Delete with foreign key consrraints

My goal is to delete selected records (from MemberMaster) and have cascading deleting on associated tables containing a matching foreign key. I’m getting a " integrity constraint violation: foreign key no action; SYS_FK_10138 table: PhoneNumbers" error. I tried to use MATCH SIMPLE ON DELETE CASCADE with my basic statement ` ` DELETE FROM "MemberMaster" WHERE "NotActive" = TRUE with no success at all. I must really be misunderstanding the constraint definition concept. Been reading about it al…