Media Summary: We look at how to create a query to search for a specific employee ID. Then we apply the same principles for a date range query. We use List boxes to edit the Department Name and Group Name and make a few other changes to complete our employee edit ... We look at a few queries that shows information about the tables and fields we created from the HSQL
Libreoffice Base 28 User Parameter Part 2 - Detailed Analysis & Overview
We look at how to create a query to search for a specific employee ID. Then we apply the same principles for a date range query. We use List boxes to edit the Department Name and Group Name and make a few other changes to complete our employee edit ... We look at a few queries that shows information about the tables and fields we created from the HSQL 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 ... We create a separate department table and we add a contact person to the department table (and a relationship for the contact ... We rename the original employees table and copy the information into a new employees table with new constraints then we ...
Add new table Control that allow us to add records directly to the
