[dba-users] Editable Form based on relational SQL query in Oo2.0 beta HSQLDB

[Helge Kraak]

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