Diagram Cascade Delete

[itflash]

Hi All

Using SQL Server 2000.

I have a diagram that I use for ref integrity in an application.

I have set up a relationship in the diagram between 3 tables (Table 1 -> Table 2 -> Table 3) and will cascade deletes downwards.

However, even though my application is locking a record pessimistically in Table 3, a user can delete everything from Table 1. It only sees locks in Table 2, but not Table 3.

Any ideas?

Thanks
ITflash

 

[evaleah]

Do you have a relationship between t1 and t3? From what you have said here it sounds like that is what you are missing.