Base: create form wizard sub-form error

users
#1

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.

I enter the Form Wizard, select Table A, include all fields, and press next.

I then select Add Subform. The system displays the expected Table B. I
select Subform based on existing relation for that table, and click next.

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.

Sure appreciate any help.

Thanks.

Blake McBride

#2

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

#3

Thanks! I am using LibreOffice Base 4.4.3.2

#4

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&t=28235

[Tutorial] Creating a form in Design view

https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=32757

[Example] Relations reflected by list boxes in forms