Am 23.10.22 um 22:20 schrieb Carlos E. R.:
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?
Hm. I have the impression that you make your life a bit complicated. As an "old linux crack" you for sure have apache and php installed. So why don't you just use phpMyAdmin? You can use it for everything, it can't be easier. Create, alter databases/tables, inline edit of records, enter, copy, delete records, search... what ever you want. If you really need it then in OpenOffice you can always export it with a click to CSV, the complete table or a selection... -- Daniel Bauer photographer Basel Málaga https://www.patreon.com/danielbauer https://www.daniel-bauer.com -- Daniel Bauer photographer Basel Málaga https://www.patreon.com/danielbauer https://www.daniel-bauer.com