Status Change History Table

I have a table that I use to track customers. I have one column that reflects the current status of the customer that is a single select for different status, for example (Active, Not Active, Waiting)

Every time a someone changes the status (which can happen multiple times back and forth between status’s) I want to record the record that changed, the status it changed to and date in another table.

Is there a way to do this?

2 Likes