Faq/Base/133/en

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.