In a Base database, I have 2 tables related in a many-to-many relationship. For example, say there is TableA and TableB. Both have Name and ID columns. TableA can have many TableB “children”, and TableB can have many TableA “children.”
I want a Form where the user can select an existing TableA Name in a ListBox, and then select several existing TableB Names in a combo box. When saved, the corresponding list of TableA-ID’s and TableB-ID’s would be inserted into a table having those 2 columns.
Is there a way to do this using Forms in LibreOffice Base?