To create the relationships, I use the "Queries" "Database" option of
Base and the "Tasks" options. I prefer to start with the "Create Query
in Design View" to do most of the work.
Seems you create the relation between tables in queries. That is not the
way to create relationships in databases. It doesn't define foreignkeys
to other tables and the behavior of a database, which should be done
when loosing the value for the foreignkey of the other table.
MyISAM-tables are a part of MySQL/MariaDB. If you have created a
database you could connect with Base to the database. You could create
tables. All this tables, which are created by GUI, are MyISAM-tables.
And this tables doesn't have functionality for creating relationships.
So Base says, when opening Tools > Realtionships: "Your database doesn't
allow to create relationships".
You have to create Innodb-tables to create such relationships with
foreignkeys. And this isn't supported by the GUI of Base. You have to do
it in direct SQL or with other tools.
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Re: [libreoffice-users] Set JRE in LibreOffice · Robert Großkopf
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy