Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-10 : 22:01:36
|
| Timothy writes "I have an linking table that has parent child relationships defined, Item IDs can appear in either the parent or child column. I would like to cascade update and delete both fields but SQL 2000 will not let me define cascading deletes and or updates on two different columns in the same table. Anybody have a way around this? If I remove the Item I would like both Parent relationship records and Child relationship records to be deleted. If I update the ID I would like it to cascade as well. Is this a trigger application?Thanks" |
|
|
|
|
|
Cascade Updates to multiple fields of the same table