Update another cell after save
When I save the record I need to update another cell based on the selected value from the list. Can you update another cell as well as the cell updated by the select choice?
Solution:
That would require two different updates. In your case, you can use database trigger to update another record when a change is made.
Mariadb.com has the best trigger example for MySQL.
https://mariadb.com/kb/en/sql-99/trigger-examples/