Saving records to connected tables

Hi, I have a working MS Access application. Now I am in the process of moving the tables to MariaDB 10 on a Synology server and use Access as a front-end. But there is one problem I could not yet solve. When I use a form for entering data into table A with a subform to enter data into table B and linked by a common key (primary key in the form with a reference key in the subform, I cannot enter any records ("Cannot save record to table B"). Has anybody a solution to this problem?

Thanks and best regards, boz


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.