Page 1 of 1

Form One to many relationships between two tables using int

Posted: Sun Nov 01, 2020 5:54 pm
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

Re: Form One to many relationships between two tables using

Posted: Sun Nov 01, 2020 10:06 pm
by Ratslinger

Re: Form One to many relationships between two tables using

Posted: Sun Nov 01, 2020 11:51 pm
by Villeroy