Re: Base form read only

> I'm answering your mail in [email protected], which is the better
> place for this kind of questions. 

Thanks Frank, am now subscribed and ready to go. (Please bear with me as I
am a newbie to Base)


> Then, is the problem only related to forms, or also to the underlying
> table, if you open this table directly?
> In general, OpenOffice.org can only update tables if they have a unique
> index, or a primary key defined, see
> http://dba.openoffice.org/FAQ/FAQ.html#dataupdate for more information.

That indeed got me a lot further, but not all the way.


> Other than this - hmm, no idea without more information.

Here goes:

MySQL 4.1.13-nt and OOo 2.0 (1.9.122)

I have two tables, StockMaster and CategoryMaster. Both have a primary index
(ItemNo and CategoryNo resp.) Stockmaster also has a column CategoryNo.

I can create a form that allows editing of the data for:

- StockMaster (the table)
- Query "Select * from StockMaster"
- Query "Select * from CategoryMaster"

But when I create a query for a select statement like "Select * from
StockMaster, CategoryMaster", i.e. a query on *two* tables, the generated
form does not allow any editing of data at all.

What am I doing wrong?

TIA
Gert