[Solved+Issue] Restrictions on modification of data in forms

[intuited]

My next step in the project that I'm working on is to set up a form to change an integer value in a table. This value sets the approval status of a manual price override for a retail item. Other fields in the table include the date, the override ID (primary key). and the retail item ID.
So that the administrator using this form will know what retail item the override is on I want to display fields from the retail items table for each proposed price override.
The retail item ID is the primary key of the retail items table. I've established a relationship between these tables:
overrides.retail item ID n<->1 retail items.retail item ID

I create a query that joins the two tables and selects related fields from each. The query is done in OpenOffice mode (the default) and not direct SQL mode.
I link a form to the query by right-clicking the query and selecting Form Wizard....
I leave unchecked the option to disallow modification of existing data.
When the resulting form is in (not design) mode, the data fields are displayed properly but I am unable to modify any of the data.

Using a Table View in place of the query yields the same result.

In contrast, if I link a form to one of the tables directly, i'm able to edit its contents when i open the form in (not design) mode. Of course the information from the other table is not displayed in that form.

Is editing data in forms based on table views and queries not supported in Base? Or is there a way around this? If not, then why does the wizard give me the option to allow or disallow modifications to the data? I could use a subform but it seems aesthetically superior to be able to edit the data right in the table using list boxes (which do work when the form is based on a table).

[r4zoli]

Editing data with forms only for tables.

[intuited]

okay thanks.

[intuited]

Adding the ability to edit more than one table in a form is a proposed enhancement for 3.x. Anyone interested in voting for it is advised to do so at http://qa.openoffice.org/issues/show_bug.cgi?id=53377.