Frequently asked questions - Base
From The Document Foundation Wiki
How do I enable updates in queries?
- The underlying tables must allow date updates. In particular a primary key field must have been defined for each of them.
- The query itself must include the table's primary key field in the assigned columns.
- This is the same for queries including more than one table: the primary key fields of each table must appear in the query.
There is an example of this situation in the tutorial Débuter à partir d'une application exemple commentée.