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

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.


-- 
Jay Lozier
jslozier@gmail.com

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