The connection type is MYSQL(native). In the wayback I vaguely remember using the JDBC connection type. I believe I switched the oldest to MYSQL(native) to solve a problem with complex querys. The newest database affected started with MYSQL(native). Perhaps the clue is in the error states verbatum: The data content could not be loaded. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':link_from_ID )'. Data is displayed for the parent table. It does not display for the subform. I just checked the form properties for the subform. The link fields had the slave in the masters position and visa versa. I flipped the order and tested the form, and voila, it works. The wierd thing is, it had been working fine for years. If the order had always been reversed.... I checked the second table and got the exact same error message. Made the identical changes on this form and ta da! Everything works. Maybe everything working before was the bug? This is fixed for me, just leaving me curious as to exactly which change led to the problem. Thanks for your help. On Thu, 2019-08-01 at 18:31 +0200, Rene Engelhard wrote: Hi again,On Thu, Aug 01, 2019 at 12:04:58AM +0200, Rene Engelhard wrote:On Wed, Jul 31, 2019 at 04:00:04PM -0500, william l-k wrote:have linked sub-forms from two seperate tables for entering related data.One of the databases started out as a libreoffice base then was convertedto a mariadb connection. The other started out as a connection to mariadb.Maybe it's not related at all but connection to mariadb how? MySQL ODBC?MySQL JDBC? (both of which are removed because being buggy), MariaDBJDBC? Or libreoffice-mysql-connector?If the latter, 5.2 removed the extension and need for libmysqlcppconnbut integrated it properly into the "main" packages |