Hi Gert, > 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?
Nothing, I fear :-\ Just recently somebody else stumbled upon this: You cannot update queries joining two tables, unless they contain (IIRC - would have to look into the code or ask my colleague :) ) a JOIN. That means that "SELECT A.a, B.b from A, B where A.b = B.ID" is not updatable. Try changing the connection between A and B: In the query design, double-click the connection line, and change it's Type to something else - does this help? Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
