Editable Form based on relational SQL query in Oo2.0 beta HSQLDB

Helge Kraak <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Hello all!

When I set the content of my form to SQL I can edit and create table 
entries without problems as long as I just select one table. With a 
relational selection (I need an 1 to 1 relation withthe  primary keys 
in both tables) it's not anymore possible to create and edit entries. I 
wanted to ask whether there is a possibilty to have a editable SQL 
based content in a form which gets the data from two tables with unique 
defined datasets? The subform function doesn't work very reliable (of 
course it's beta) and it also complicates macro querys on the form 
content. I would like to be able to just reload the form by macro, just 
changing the SQL statement for the form content

I would very much appreciate hints!

Best regards
Helge Kraak
.
--
Helge Kraak
Frauenlobstr. 78a
60487 Frankfurt am Main
Germany

Mobil:     +49 (0)178 828 80 90
Telefon:   +49 (0)69 979 466 23
Fax:       +49 (0)69 133 046 094 11
Internet:  www.helge.kraak.info
ICQ:       348131950
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.