Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

Hi Girvin,

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:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.