[libreoffice-users] Re: Base: create form wizard sub-form error
Le 23/12/2015 17:21, Blake McBride a écrit : Hi Blake, > Then, on the "Select the fields of your subform" screen it has Table E > pre-selected and grayed. It also shows the columns for Table E. > > 1. Table E has no columns that directly relate to Table A (or B). > > 2. In the prior screen, Table B was correctly identified and selected. > > I have no idea why it is selecting Table E, and I have no way to change the > selection since the combobox is grayed out. That sounds like a bug. As you don't say (or I didn't see) which Linux distrib you are using and you don't say whether you are using the distrib-provided version of LibreOffice as opposed to the TDF download, it is hard to know whether the problem is a TDF one or a packaging one. There have been problems with the wizard in the past with regard to subform creation, so it would probably be best if you set up your subforms manually using in Form design mode rather than using the wizard. In Form design mode, you can activate the Form navigator, in which you see a tree represenation of the form hierarchy with its various form controls. You can add your subform to the main form via this navigator, and set the bound controls accordingly. You might find more relevant help by reading the Base manual, available here : https://wiki.documentfoundation.org/images/e/e8/BH40-BaseHandbook.pdf Page 104 deals with using the Form navigator to set up subforms. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
Re: [libreoffice-users] Re: Base: create form wizard sub-form error
Thanks! I am using LibreOffice Base 4.4.3.2 On Wed, Dec 23, 2015 at 11:20 AM, Alexander Thurgood < alex.thurg...@gmail.com> wrote: > Le 23/12/2015 17:21, Blake McBride a écrit : > > Hi Blake, > > > > > > Then, on the "Select the fields of your subform" screen it has Table E > > pre-selected and grayed. It also shows the columns for Table E. > > > > 1. Table E has no columns that directly relate to Table A (or B). > > > > 2. In the prior screen, Table B was correctly identified and selected. > > > > I have no idea why it is selecting Table E, and I have no way to change > the > > selection since the combobox is grayed out. > > That sounds like a bug. As you don't say (or I didn't see) which Linux > distrib you are using and you don't say whether you are using the > distrib-provided version of LibreOffice as opposed to the TDF download, > it is hard to know whether the problem is a TDF one or a packaging one. > > There have been problems with the wizard in the past with regard to > subform creation, so it would probably be best if you set up your > subforms manually using in Form design mode rather than using the > wizard. In Form design mode, you can activate the Form navigator, in > which you see a tree represenation of the form hierarchy with its > various form controls. You can add your subform to the main form via > this navigator, and set the bound controls accordingly. > > You might find more relevant help by reading the Base manual, available > here : > > https://wiki.documentfoundation.org/images/e/e8/BH40-BaseHandbook.pdf > > Page 104 deals with using the Form navigator to set up subforms. > > > Alex > > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > 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 > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
[libreoffice-users] Re: Base: create form wizard sub-form error
Am 23.12.2015 um 17:21 schrieb Blake McBride:
> Greetings,
>
> I am using LibreOffice Base 4.4.3.2 on 64 bit Linux with a PostgreSQL DB.
>
> I have a hierarchy of tables such that:
>
> Table A
> Table B (many B to one A relationship with Table A)
> Table C (many C to one B relationship with Table B)
> and so on...
> Table E
>
>
> I am trying to use the Form Wizard to create a form that allows the user to
> edit tables A and B only.
>
Forget the form wizard. It is close to useless. Get the "Form Design"
toolbar. Hit the 5th button ("Form Navigator"), right-click the forms
collection and start your own hierarchy of forms and subforms with grids
and list boxes. Subforms and list boxes are the elements which help you
to edit 1-n relations and m-n relations as well.
[Tutorial] Forms in OpenOffice.org Base
> https://forum.openoffice.org/en/forum/viewtopic.php?f=83=28235
[Tutorial] Creating a form in Design view
> https://forum.openoffice.org/en/forum/viewtopic.php?f=83=32757
[Example] Relations reflected by list boxes in forms
> https://forum.openoffice.org/en/forum/viewtopic.php?f=100=40444
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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
