How to delete Master Record if Detail Records exist?

Applications Forms
#1

i hit an error while try to delete the Parent record when Child records exist (plz refer attached images)
I know the workaround is to manually delete ALL the linked child before remove parent.

But is there a friendly way, like SC could auto backend delete the child records when i delete the parent?

Thanks for the pointers

delete middle.jpg

delete show error.jpg

#2

Also, how can the change of Key field ‘Effdt’ in Master form able to auto change the ‘Effdt’ in detail form?

#3

You have to create the foreign key with cascade on delete see this article below.

http://stackoverflow.com/questions/2914936/mysql-foreign-key-constraints-cascade-delete

#4

Thanks and SC provided such feature as well

cascade delete.jpg