This is what I get. Any ideas why it does not cascase delete? I do not see mention of tblClientItem.
/****** Object: Index [PK_tblClient] Script Date: 16/12/2012 3:23:48 µµ ******/
ALTER TABLE [dbo].[tblClient] ADD CONSTRAINT [PK_tblClient] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
visakh16, regarding the use of triggers/procedures it is probably a more proper way to go, but was curious to see the reason why the cascade delete did not work.