Auto update value in entire column

[AllJazz]

There is a database with car mileage. Data is entered continuously. In another table, you need to transfer the last maximum value from the database to the "Current mileage" column. In this case, the last maximum value should automatically update the entire column.

[AllJazz · Accepted solution]

Fixed by adding virtual column with MAX() expression.