If you find these tutorials useful, Please consider making a donation.

TheFrugalComputerGuy.png
TheFrugalComputerLogo.png

LibreOffice Base - Group 17

Multi-Table Forms










Video 46 - Form from Queries

We create queries to capture the data we want to show on an employee view form (with a subform) and see why one query allows updates and the other does not.










Video 47 - Edit Form Part 1

We start creating the Employee Edit form by placing the fields we want to see on the form, we add our sub-form from our existing relations, and re-position our fields. We will change the Department-ID and Group-Id to Department Name and Group Name in part 2.










Video 48 - Edit Form Part 2(ListBox)

We use List boxes to edit the Department Name and Group Name and make a few other changes to complete our employee edit form