How To Create A LibreOffice Base Form with Sub Form
How to build a form and subform in LibreOffice base without needing any code.
LibreOffice (Open Office) Base programming book with reviews (affiliate) https://amzn.to/35wqtuI
In this video, I create a LibreOffice (or openoffice) multigrid form that filters a database table based on a sql query of the year column within that table.
This tutorial covers setting up the LibreOffice form environment to make it easy to design your database form, this includes making the "Form Controls", "Form Design" and "Standard" toolbars visible and hiding toolbars that are not essential so as not to clutter your LibreOffice base interface.
Using the "Form Navigator" on your "Form Design" toolbar to correctly assign your form controls to the correct data source.
I also explain how to link the form and subform together using "Link master fields" and "Link slave fields" on the form control properties.
Blog Post Link for this video https://www.businessprogrammer.com/libreoffice-base-form-subform-how-to/
☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee...https://www.buymeacoffee.com/seanjohnson
☕
#libreoffice #openoffice
DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I’ll receive a small commission.
Видео How To Create A LibreOffice Base Form with Sub Form канала Sean Johnson
LibreOffice (Open Office) Base programming book with reviews (affiliate) https://amzn.to/35wqtuI
In this video, I create a LibreOffice (or openoffice) multigrid form that filters a database table based on a sql query of the year column within that table.
This tutorial covers setting up the LibreOffice form environment to make it easy to design your database form, this includes making the "Form Controls", "Form Design" and "Standard" toolbars visible and hiding toolbars that are not essential so as not to clutter your LibreOffice base interface.
Using the "Form Navigator" on your "Form Design" toolbar to correctly assign your form controls to the correct data source.
I also explain how to link the form and subform together using "Link master fields" and "Link slave fields" on the form control properties.
Blog Post Link for this video https://www.businessprogrammer.com/libreoffice-base-form-subform-how-to/
☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee...https://www.buymeacoffee.com/seanjohnson
☕
#libreoffice #openoffice
DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I’ll receive a small commission.
Видео How To Create A LibreOffice Base Form with Sub Form канала Sean Johnson
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Code In LibreOffice Base - Simple FormOpenOffice Base Tutorial - Edit and Design Database Forms by VscorpianCLibreOffice Base (33) Creating a Simple SubformLibreOffice Base (36) Adding a Subform (to an existing form)Expert to Expert: Rich Hickey and Brian Beckman - Inside ClojureLibreOffice Base Insert Dynamic ImageGetting Started with LibreOffice BaseLibreOffice Base (62) Standalone SwitchboardLibreOffice Base (61) Standalone FormsLibreOffice Base (09) Protect a Field, Sort, Add ButtonsLIBREOFFICE BASE - CREATING A FORM WITH MORE THAN ONE SUBFORMLibreOffice Base - FormulareLibreOffice Base (34) Creating a RelationshipLibreOffice Base (93) odb93 MySQL SearchFormLibreOffice Base (51) ListBox ValueListlibreoffice base database exampleSolving Problems the Clojure Way - Rafal DittwaldLibreOffice Base (06) Creating a formLibreOffice Base using MySQL Backend.LibreOffice Base (14) Form Properties