RE: Re: Base form read only

 > 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?

It didn't. The standard INNER JOIN indeed generates "Where x = y" statement.
Changing it to LEFT JOIN generates a JOIN (RIGHT JOIN doesn't seem to be
supported):

SELECT `categorymaster`.`Category`, `categorymaster`.`Description`,
`stockmaster`.`ItemNo`, `stockmaster`.`Description` FROM { OJ
`newstock`.`stockmaster` `stockmaster` LEFT OUTER JOIN
`newstock`.`categorymaster` `categorymaster` ON `stockmaster`.`Category` =
`categorymaster`.`Category` }

But the generated form on this query also does *not* allow any editing.

Any further ideas?

Cheers
Gert