My parent table has a column (Survey Status) to indicate the status of that record.
At this point I ask my users to manually update the status of old records from Latest to Previous.
But of course after only a few surveys I end up with multiple Latest records as Latest is given upon creation and my users forget to update the old record.
I don’t blame them it’s not user friendly.
How can I make it so that when I create a new record in my table the column (Survey Status) value of the previous record will be updated from Latest to Previous?
I’m pretty sure it’s an easy solution but I can’t get my head wrapped around it.