I am having problems with cascade delete of the child records (they do not get deletd). Assume tblClient with field lngID (PK) and tblClientItem with field lngClientItem (FK). I used a Database Diagram and created a FK with these two fields. I also set the Delete Rule to Cascade. When I delete a specific record in lngID the corresponding lngClientItem records do not get deleted.

In SSMS Object Explorer, and find the table name. It will be under the Databasename -> Tables. Expand the table node and find the Keys node. Right click on the keys and select Script Keyas -> Create To -> New Query Window. Alternatively, you can right click on the table name and do the same thing - it will script the table along with keys.

I really prefer implementing trigger/procedure based logic over cascading deletes. The reason is unless proper documented cascading deletes can be a real pain in maintaining moving forward. Imagine case of someone inheriting DB without having any documentation on cascading deletes. As there's no direct accountability they wont be aware of impact caused due to cascadng deletes especially in cases where there's no auditing/logging