It will not by default. You would have to create a view to define the referenced tables you want deleted and their relationship, then deleting from that view should delete the referenced tables as you have defined it.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.