SQL server allow foreign key/ relationship to have cascade update/deletion. I feel they are useful sometimes so hopefully you guys can support this feature.
Has been implemented.
Select relationship then go to Relationship properties sidebar and open tab "Options".
We are glad you created this "Idea" ticket. We will discuss it with our team and work on it, in case there are significant number of user votes for this.
Thank you for your assistance,
Customer support service by UserEcho