I have three tables in SQL Server 2008 and they all have the PK-FK-FK-relationship.
1st table: I have a column name with the name as "STATUS" that contains the value "active" or "inactive".
2nd table: I have the column with the name FKNEWLoanReviewfieldid, which has multiple values
3rd table: The column is FKWwarningtypeID that has different values.
I'm trying to create a trigger so if "FKWarningtypeID" is updated to a value 4, then first column value of status should be modified to active.