I need to update a specific field in another table when one field in my table gets updated.
Table that is getting updated: tbltimesheet
Fields that could change: comments
pk field : timesheetid
Table to update: tblweek
field: status
Forign key field:timesheetid
The goal is to update the status field when comments field gets updated. I wanted to use update trigger .I am using SQL SERVER .any help would be appreciated.