> 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
