Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

"SubForm not linking to master form" can happen for one other reason as well.

If connecting to a MariaDB (or possibly a MySQL) database, there are two possible methods to connect using JDBC, and one of the methods works, and the other method does not.

You need to first select MySQL, then JDBC, not simply JDBC. If you don't get this right, you will be able to see your tables, but if you try and create a form with a linked subform it won't work. Also if you try and select Tools,Relationships..., you won't be allowed to view or edit your relationships.

(Note for MySQL/MariaDB your database must be using the InnoDB database engine, which natively supports maintaining table to table relationship integrity without the use of transactions, and not something like the ISAM database engine, which is faster but doesn't have native support for relationships without transactions.)