>>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.
>
>It is called cascading deletes.
>
>Explained here..
>
>
http://msdn.microsoft.com/en-us/library/ms186973.aspx>
>You can accomplish this in SSMS as well. Right click on a table, select Design. Then click on the Relationships button (wierd looking toolbar button). you can set up relationships and set cascading properties from there.
Thank you very much. This is what I forgot, the "CASCADE" word.
"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