In Microsoft Access when you have a table with a field that has a one to many relayionship with a field in another table you can show the second table as a subdatasheet in the main tables’s datasheet view.
This means that you can edit the content of the second table confident of keeping everything in sync.
For clarity here is an example of how you do it in Access: https://access-excel.tips/access-table-add-subdatasheet/
How do you do this in Base?
This link seems to point to Forms. Am I limited to a Listbox within a form for editing the second table?
Forms are the user interface where you edit your data.
Base has no “lookup fields” as described in The Access Web - The Evils of Lookup Fields in Tables
So, is there a help page that shows you how to include another table as a “subform” for editing within the main form. It needs to be in a datasheet / grid format as there may be multiple rows to edit?
If you prefer to read online use the link “read in your browser”:
https://documentation.libreoffice.org/en/english-documentation/
This was the sort of instruction I was looking for.
https://www.businessprogrammer.com/libreoffice-base-form-subform-how-to/
In reality the real challenge turned out to be finding and then using the “Form Navigator”.