I'm new to LO base (I'm using the default HSQLDB), and having a pretty
good time with it so far, but have run into something I don't
understand, and cannot find documentation about.
I have a form with a main db displayed in a grid control. Linked to it
is a detail db displayed in a subform. So far, so good.
I want to pull out some fields from each db for display in text boxes.
With the subform, this is a necessity, if I am to have full access to
the data in a memo field.
With the main form, pulling out data into a text field (two of them,
actually) is more a matter of giving visual emphasis to the contents
of the fields involved.
So...two dbs, two forms, and I want data from each db shown in text
boxes.
The problem: When I specify the record data to be shown in one db's
text boxes, then do the same with the other, the settings in the first
disappear. Either, alone, work fine. When both are specified, only the
last one I specify "sticks" and actually shows up in the displayed
form. The problem is entirely consistent. After many tried to get
things to work, the problem remains.
This seems nuts to me, but it occurs to me that it may be a limitation
of LO or HSQLDB.
Can anyone shed some light on my problem, or perhaps suggest a solution.
Thanks in advance for any help you can give!
Tom Cloyd