Welcome beginner. What is your question or comment?
Please try to briefly and clearly tell us: What you want, What you tried, and What happened.
-----------------------------------------------------------------------------------------------------------
I created a mainform with a subform using the wizard - I needed another subform so I added a subform in the form navigator under the Mainform but it does not appear - how do I get this second subform to appear in the main form - or for that matter if I have to move the fields in manual from this third table, how do I do this? I cannot even see the fields to drag and drop or is this something that oo does not do. Please help - losing it!
Subforms
Re: subforms
The subform does not appear as a visual element. It's just a logical level relating to a dependent data source, so you'll only see it in the form navigator.
Your main form is where you connect your main data table. Dependent tables are connected to subforms.
You can then add controls to each subform level, and select data field(s) for each control from the connected table.
You can place main and subform controls wherever you like on your form. Venturing beyond the limited capabilities of the form wizard, creating a visual layout that reflects the logical structure is entirely up to you.
Your main form is where you connect your main data table. Dependent tables are connected to subforms.
You can then add controls to each subform level, and select data field(s) for each control from the connected table.
You can place main and subform controls wherever you like on your form. Venturing beyond the limited capabilities of the form wizard, creating a visual layout that reflects the logical structure is entirely up to you.
Apache OO 4.1.12 and LibreOffice 7.5, mostly on Ms Windows 10