Form to fill data of 3 and more tables

[MasterChief113]

I am new to Libreoffice. I created a db with 5 tables and established relationships between the tables. After I created 1 form and manually modified it to fill 3 different tables, but when I try to use this form I keep getting thrown out. I suspect the error is in the last 3 fields of the form, but have not found a solution. This database is part of the assignment and the assignment requires the use of Microsoft Access, but I am a supporter of free software and want to complete the assignment using free software. The DB is in russian language, but if its a problem i can rename all of its content

Translated with DeepL Translate: The world's most accurate translator (free version)
Библиотека.odb (4.3 KB)

[Villeroy]

[Example] Relations reflected by list boxes in forms

[MasterChief113]

Thank you for your reply. I found a solution to my situation. I redesigned the form and used Tables, SubForms and Master and Slave fields instead of SQL commands.