You could do something like this by adding in an update to the page. The update server behavior would need to update any of the records in the table where the active was set to 1 and the id was not for the just inserted record, it will need to update this to be 0 for all of the others.
It can become quite a bit more complex than this depending on exactly how you would like it to work but this is the general idea.