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