>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.aspxYou 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.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________