Change Value in Multi Rows

[Fabio_T]

I have a table with three columns; order, number, status,
I would like the status to change in value when I enter a new order that uses the same number, for all rows.. that contain the same value in the number column

That is, I have an order with number 333 with active status, and when I insert another order with number 333 I would like the previous status to become inactive and the latter insert Active. It is possible via action or bot.

Thanks More