Re: [libreoffice-users] LO base: text field problem in master-slave form

Well, I write lots of notes for /myself/, as I don't like to trod the 
same jungle path more than once (and there's a lot of jungle out there!).

I'm headed over to the website right now to get involved formally.

Thanks for the encouragement.

t.

On 06/17/2011 12:20 PM, planas wrote:
> Tom
>
> On Fri, 2011-06-17 at 02:22 -0600, Tom Cloyd wrote:
>
> > Just found the answer. I may be misleading myself at times due to [a]
> > prior experience of several years duration with MS Access, and [b] my
> > being very new to LO base.
> >
> > What doesn't work is to add text box control to a form and specify their
> > data, in their properties, as a field in the main table. Do that and you
> > get the problem I outlined below.
> >
> > What does work is, in design mode, to select the grid control, then
> > click the "add field" icon in the toolbar at page bottom, THEN select
> > from this list desired fields.
> >
> > NOW I have data showing up in ALL text boxes on the form. Lovely!
> >
> > Tom
>   On 06/17/2011 01:06 AM, Tom Cloyd wrote:
>
> > > 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
> Thanks for the notes, they are very useful for documentation of Base for other users.


--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted