Create a record in a table based on value change of a field in a second table
I have a request table and a log table which are related. If someone changes the Status field of a record in the request table, I want a new related record to be created in the log table to record that change.