Re: [libreoffice-users] Set JRE in LibreOffice

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.

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy