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