I have 2 tables, 1 for patients and 2 for notes as a child for the patients table, when I delete a patient, the notes assigned to this patient is still staying on, is there away they should be deleted automatically once I delete a patient?
I have 2 tables, 1 for patients and 2 for notes as a child for the patients table, when I delete a patient, the notes assigned to this patient is still staying on, is there away they should be deleted automatically once I delete a patient?