I’d like to connect a notes table to jobs table, so that any job can have multiple notes attached. So far - so good. I have connected the two tables in a one to many relationship and all goes well, but when I delete a parent record that has one or more child records, the parent (job) gets deleted but not the connected child (note) records. Instead of being deleted as I had expected, the attached notes have the connecting field blanked and they remain.
Is there a way to have the dependent child pages automatically deleted when the parent records are deleted as is standard practice with relational databases?