I should know this by now but I just can't figure our how to set this type of RI in SQL Server.
Here is an example:
Parent Table has PK column PK_FLD (Identity column)
Child Table has FK column PK_FLD which is populated when a record/row is added to the child table.
How do I set up the RI such that when the record in the Parent table is deleted, all child records where the PK is referenced is deleted too?
TIA.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
