Form One to many relationships between two tables using int

Creating and using forms
Post Reply
lomacro
Posts: 1
Joined: Sun Nov 01, 2020 5:49 pm

Form One to many relationships between two tables using int

Post by lomacro »

Hi,
I have 3 tables: table1, table2 and table3. Table1 has a one-to-many relationship with table2, but this relationship is through table3. Table1 has the following fields: "id_t1" and "names of t1"; table2 has the following fields: "id_t2" and "names_t2"; and the table3 has the following fields: "id_t3", "id_t1" and "id_t2". I wish I had a form that shows me two "table controls", the first "table control" (table_control1) is link with table1 and the second "table control" (table_control2) is link with table2, of course the (table_control2) must show the records that the one-to-many relationship establishes with table1.
Thanks in advance
LibreOffice 6.4 in debian
Ratslinger
Posts: 34
Joined: Sun Mar 01, 2015 3:34 am

Re: Form One to many relationships between two tables using

Post by Ratslinger »

LibreOffice 7.0.2.2
OpenOffice 4.0.1
Ubuntu Mate 20.04.1
Mint 20.3
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Form One to many relationships between two tables using

Post by Villeroy »

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply