1. Increase the column length of CustomerID column of "Orders" table. Currently the column length is less than 8. Make it 8 or above it will work, I hope.
2.Another issue, to make an update able view, keep the following options in mind:
The SELECT statement must only refer to one database table.
The SELECT statement must not use GROUP BY or HAVING clause.
The SELECT statement must not use DISTINCT in the column list of the SELECT clause.
The SELECT statement must not refer to read-only views.
The SELECT statement must not contain any expression (aggregates, functions, computed columns…
The above points taken from the link below:
http://www.mysqltutorial.org/create-sql-updatable-views.aspx[
^]