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

Well, nuts. You really know how to get to me. I love databases, and I'm 
coming to love this one (after about 6 days of work with it), and its 
manifestation in LO seems versatile, rock solid, and damn poorly 
documented. Oh...that last on does NOT cause love.

However, I love to document stuff (shouldn't say that, I know, but it's 
true). So...yeah, I 'll join up. I'm seriously going to be working this 
db hard, and I might as well help others when I can, as I really really 
have had rather little trouble getting it to work for me.

How did I find the answer? It wasn't any documentation, for sure. I just 
kept coming at the problem until I got a new idea that actually worked.

I just solved my other problem too (other thread) and will report on it 
there...

OK...off to sign up. This really is important - a fine db (which is what 
HSQL truly) secretly hidden in LO. WooooHooo indeed.

t.

On 06/17/2011 02:58 AM, Tom Davies wrote:
> WooooHoooo :)
>
> So, you have fixed your own problem!?  How did you find the answer?
> Documentation or experimentation?
>
>
> Do you have time to join the Documentation Team and perhaps help them for maybe
> a few hours a week or something?  Base documentation needs a lot of work and
> there are not many people that understand relational database programs.  There
> are various 3rd party documents in copy-left agreements that could be used or
> reffered to to help.  If you don't have time right now then don't worry.  There
> are a couple of people already but help is always appreciated :)
>
> Congrats and regards from
> Tom :)
>
>
>
>
> ________________________________
> From: Tom Cloyd<tc@tomcloyd.com>
> To: users@global.libreoffice.org
> Sent: Fri, 17 June, 2011 9:22:12
> Subject: Re: [libreoffice-users] LO base: text field problem in master-slave
> form
>
> 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
>
> -- 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


--
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