(LibreOffice 6.2, Integrated Firebird )
I have 3 Tables, we’ll call them “Object” and “Component” + “JunctionObjectComponent”
I need to create a form to ADD an “Object” in the “Table”.
This Object contains a lot of information (no problem)
but a particular piece of information is a list of Components of a certain type in a number of them.
So I created the junction table with ObjectID, ComponentID, ComponentNumber.
I also created the relation on ObjectID between the “Object” table and the “JunctionObjectComponent” table 1 to N
and on the ComponentID between the “Component” table and the “JunctionObjectComponent” table 1toN
How can I create a form to add/update onbjects to the “Object” table and add/update the “JunctionObjectComponent” table?
Thanks by Advance.