On Sun, 23 Oct 2022 22:20:09 +0200 (CEST), "Carlos E. R." <robin.listas@telefonica.net> wrote:
After several years, I'm finally progressing with LibreOffice Base.
I have a catalogue of my books in MySQL, done with the application Rekall (KDE3). The app is not maintained, so I have been trying for years to migrate to something else, the obvious one LibreOffice Base.
It is more difficult that Microsoft Base, which I learned to use without documentation in a month back in 1998.
It appears that the trick is that to write to my table I have to use a form, not a table. See what I have (created by the wizard, then modified):
<https://susepaste.org/56891822>
Top is the table as is, and in the subform below are the controls.
See the first row, with a "0_test" book selected. The same book is displayed below. The data Autor, SegundoAutor and TercerAutor display the numbers 1, 2, 3, corresponding to an auxiliary table of authors. The entries below in white background show the text, the names of the first author, second and third, selectable from the list. This has been the hurdle for years (true, I have not dedicated intense study to it).
(In Rekall, or in Office, I get the name of the authors directly in the main table. It knows how to handle the relationship automatically, r/w. It was trivial).
Is it really not possible to have the data from the auxiliary table, instead of the index value, shown in the main table view? That is a poor human interface for L.O. Base. Indexes are just visual garbage.
The simple detail that remains now is to join the label "Autor 1" to the control below, so that when I click there in design view both move as a single object.
So the box on the left containing "Isaac Asimov", with "Autor 1" above it, is a list box control, and you want "Autor 1" to move together with the box when you move it. Open the properties dialog (General tab) for the list box and set 'Label Field' to "Autor 1". Or, if that doesn't work, set 'Name'. [3]
I have not seen this in the tutorial:
Getting Started Guide 7.3 Chapter 8, Getting Started with Base Relational databases in LibreOffice
<https://wiki.documentfoundation.org/images/9/99/GS7308-GettingStartedWithBase.pdf>
This has been done automatically somehow by the wizard in all the controls it has created. But I do not know how to replicate, and it should be trivial.
Somebody knows?
Not me. I'm just guessing. [3] Base Guide 7.3, Chapter 4, Forms, section 'Default settings for many controls', p176,177 https://documentation.libreoffice.org/en/english-documentation/ , 'Download PDF' link for 'Base Guide' (choice of languages at top of the page) -- Robert Webb