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+unsubscr...@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
