Ch 11 Creating relationships between tables
In previous versions ASP.NET relationship dialog box had option: "Cascade Delete Related Records"; it was radical solution for keeping data integrity. If this option selected and you delete a department from the database, all its related categories would be automatically deleted by SQL Server. I used this option in my previous projects to let users delete ( after confirmation) record from parent table with all corresponding records in related tables. I don't see this option in ASP.NET 3.5.