I had the same probblem & solve it after I put a new field in a table called UNIQUE C(10) & after adding a reccord (only after adding, not anytime you change record or you open table) in a table I fill it with SYS(2015) or some other unique value. This field I make Key field in a View & I don't have a problem with Update anymore.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.