[libreoffice-users] Re: Base: invisible subform - what to do?

Am 22.06.2011 07:16, Tom Cloyd wrote:
> I just tried out the form wizard, and got exactly what I want...so is
> this the only way to get a subform grid onto a main form? I sure hope
> not. Meanwhile, my original form has 5 list boxes on it that I
> painstakingly set up. Since I cannot get a subform grid onto that form,
> I seem to have to abandon it.
>
> I'm hoping there's a better way out there!
>
> Meanwhile, here's the procedure (again - this should be plain and
> obvious, in the documentation, and if it is I haven't seen it):


List boxes are the key element to reflect database relations with 
primary and foreign keys. Forms, subforms, list boxes and sometimes 
tables with list boxes make your interrelated tables editable as if they 
were in one table while hiding away all the keys from the user. All the 
other elements (such as date fields and combo boxes) are input helpers 
for one distinct field in one distinct table.
Unfortunately, the form wizard is close to useless since it is limited 
to one subform and it never creates any list boxes.
The "Form Design" tool bar provides the most useful tool set do create 
arbitrary complex hierarchies of forms, subforms, list boxes to reflect 
your database relations in an editable form.

The ultimate guide by a true professional: 
http://openoffice.org/projects/documentation/downloads/directory/Base/Mid%20level%20Base%20tutorial
My own ramblings with a small database attachment: 
http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=40444


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