Is there a way to delete rows while automatically deleting other rows dependent on those rows?
There are a number of ways. Here's three: 1) ON DELETE CASCADE 2) Write a trigger for the table which implements the delete logic. 3) Always update the table via a stored procedure, and have that stored procedure implement your delete propagation logic. thanks, bryan
