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 jsloz...@gmail.com -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@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