I need a little help with creating trigger. I am trying to update a particular field in one table after a change is made to a field in another table.
Here is the scenario:
A user will update a field;this field will become a null value. At this point, I would like a field in another table to become blank.
I think my issue is that the table that is being updated by the user does not directly link to the table being updated after the trigger.
Here is what I have:
CREATE TRIGGER reset_Assign
ON 1sttable FOR UPDATE
IF update(hCurrentCamRule) /*field from 1sttable */
IF NULL = (Select i.hCurrentCamRule From inserted i)
IF 'Garage' = (Select i.sDesc from Inserted i)
IF Exists (Select * from 2ndtable b Inner join inserted i2 on i2.hCurrentCamRule = b.hMy
join 3rdtable c on c.hCode = b.htenant)
UPDATE 3rdtable set sfield = ''
From 3rdtable c2 Join 2ndtable b2 on c2.hCode = b2.htenant join inserted i3 on i3.hCurrentCamRule = b2.hMy
Any help would be appreciated.