USE Northwind
GO

CREATE TABLE myTable99(Col1 char(1) PRIMARY KEY,Col2 varchar(25))
GO

CREATE TABLE myTable00(Col1 char(1), Col1a char(1), Col2 varchar(25)
	, PRIMARY KEY (Col1, Col1a)
	, FOREIGN KEY (Col1) REFERENCES myTable99(Col1)
		ON DELETE CASCADE
		ON UPDATE CASCADE
)
GO

INSERT INTO myTable99(Col1,Col2)
SELECT 'A','The Letter A' UNION ALL
SELECT 'B','The Letter B' UNION ALL
SELECT 'C','The Letter C'
GO

INSERT INTO myTable00(Col1,Col1a,Col2)
SELECT 'A','1','The Letter A' UNION ALL
SELECT 'B','2','The Letter B' UNION ALL
SELECT 'C','3','The Letter C' UNION ALL
SELECT 'A','4','The Letter A' UNION ALL
SELECT 'B','5','The Letter B' UNION ALL
SELECT 'C','6','The Letter C'
GO

SELECT * FROM myTable99
SELECT * FROM myTable00
GO

UPDATE myTable99 SET Col1 = 'D' WHERE Col1 = 'A'
GO

SELECT * FROM myTable99
SELECT * FROM myTable00
GO

DELETE FROM myTable99 WHERE Col1 = 'B'
GO

SELECT * FROM myTable99
SELECT * FROM myTable00
GO

DROP TABLE myTable00
DROP TABLE myTable99
GO