Help enhancing a LibreOffice Base application

This project is for Farhin B to provide guidance for me to enhance my Librebase application on a time & material basis. Frequently I get stumped by a programming issue and will reach out to Farhin for advice. So the issues will be individual things like adding a button to a form to initiate a report or display a text string on a report when a condition is true. To clarify this project is for on-going help, not for addressing an individual issue.
Some background:
I’m currently running LibreOffice version 24.8.3.2 (AARCH64) on a Mac under MacOS 15.6.1. Java is Oracle 23.0.1. I’m using LibreBase’s built in DB engine (HSQLDB). All macros have been written in Basic. I developed my Base application myself and it has been running, with limitations, for over a year. The application I’m developing is used to store the data needed to run a small aircraft maintenance facility. The application involves three tables, a customer table, an aircraft table and a work order table. A customer may have 0-to-many aircraft, and 0-to-many work orders for each aircraft. I have a single form that displays the fields from the above tables.