[plug] OpenOffice.org data connection - Database for the rest of us

[J Michael Gilks]

> > If you create a child form that is a simple table view then you can do
> > all the normal data manipulation, update, delete add etc.
>
> Yes, but it doesn't seem to be possible to ensure that it stays looking
> at the same record as the master form (in a single-table mode) or
> otherwise make what it shows dependent on the master form. You can do
> this with a query, but then you go back to the read-only issue.
>

When creating the subform you start with a table view, but must change the 
data to an SQL command to link the forms.
Check out the tutorial at
http://documentation.openoffice.org/HOW_TO/data_source/how_to_link_tables_using_named_parameters.sxw
Pages 24 to 36 show how to link forms to get editable results and page 46 
shows an example using a complexer query to reference three tables.

Hope it helps.

Love
Mike.