Hi,
I have a form and a subform based on parent-child tables in MySQL (one-to-many relationship). The subform displays correctly the records related to the current record in the main form. The problem is the subform field corresponding to the foreign key always displays the value 1000000. Which is, by the way, the “Value max” property of that column. This happens with all the records in the main form, excepting the first one. Anyway, if I’m looking in the database, the foreign key in the child records is added correctly. The datatype of the indexed columns is INT. Now, this could be a bug in Base but… maybe I’m missing something. Any idea, please?
Windows 8.1 x64
LibreOffice 6.3.2.2 x64
MySQL 5.7.27 x64
Connector ODBC 8.0.17 x64
And the screenshots: