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?