Update a field the previous records

Hi, I have a table, say it has 3 fields; Name, Date, Status.

Status can take two Values Active/InActive

Whenever a new record added, I need the status of all previous records should be changed to InActive.


Any idea to deal with this situation?