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
Form One to many relationships between two tables using int
Form One to many relationships between two tables using int
LibreOffice 6.4 in debian
-
- Posts: 34
- Joined: Sun Mar 01, 2015 3:34 am
Re: Form One to many relationships between two tables using
LibreOffice 7.0.2.2
OpenOffice 4.0.1
Ubuntu Mate 20.04.1
Mint 20.3
OpenOffice 4.0.1
Ubuntu Mate 20.04.1
Mint 20.3
Re: Form One to many relationships between two tables using
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice