Page 1 of 1

Relationships between MySQL tables (LibreOffice)

Posted: 20 Nov 2021, 03:10
by zoomiest
I just connected LibreOffice Base to my CATS database on the remote server, and I am trying to establish the relationships between the tables.

1. Is there a schematic model that has been published of the relationships between the tables?

2. How do I set the update options and delete options? Here is the options I am seeing:
Image

I can't find any good documentation on this. Is anyone else querying their OpenCATS database on LibreOffice? I am getting a variety of errors, depending on which settings I try...