I have a query that has a single table linked one-to-one to two other
tables.

I want to update a field that exists only in one of the tables. This field
is not generated by code or filled in by the query.

Apparently, I can't update anything.

What makes the fields in a query not updatable? Is it possible to redo the
query so that I can change this data?