On Sun, 23 Oct 2022 22:20:09 +0200 (CEST) "Carlos E. R." <robin.listas@telefonica.net> wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
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).
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. 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?
Undoubtedly one of the experts on the libreoffice mailing list users@global.libreoffice.org will be able to answer. See https://www.libreoffice.org/get-help/mailing-lists for details, or if you prefer Spanish then look at https://wiki.documentfoundation.org/Local_Mailing_Lists#Spanish (obviously I don't know what level of expertise is on the Spanish lists)