Getting started with LibreOffice Base
|
Off to New Shores
I'll recap the function of the category system in Figure 10. The main form has an open record in Images . Matching with its id , the subform selects records from the ImageCategories pivot table based on the link Image.id = ImageCategories.ImageId .
The table control element contains a list box row in the subform record that shows the category names matching the CategoryId from ImageCategories . You can also use it to add new CategoryId s.
Although the form wizard relieves you of some effort, the second part of this workshop will show you that Base, like MS Access, can't solve all problems without requiring some knowledge of the SQL database programming languages. Further details and practical examples are available as PDF and OpenDocument files in the official Base handbook [2], which goes much further than the online help for the product.
Infos
- LibreOffice Base: http://www.libreoffice.org/discover/base/
- LibreOffice documentation: http://www.libreoffice.org/get-help/documentation/
« Previous 1 2 3 4 Next »
Buy this article as PDF
Pages: 6
(incl. VAT)
Buy Ubuntu User
US / Canada
UK / Australia
Related content
-
LibreOffice Base
A database without a search function is like a car without an engine. The second part of our Base series is dedicated to implementing a database search.
-
Managing an Inventory with PartKeepr
Staying on top of stock inventory levels will allow you to plan for capacity and profit. PartKeepr will help you out.
-
Working with SQLiteStudio
SQLiteStudio, a compact graphical tool, lets you complete everyday tasks relating to SQLite databases quickly and easily.
-
Publishing books with LibreOffice, CreateSpace, and KDP
In the past, publishing a book meant sending it to a publishing house. With Amazon's CreateSpace and Kindle Direct Publishing, you can now publish on your own. This article will guide you through the process.
-
Managing personal finance with Grisbi
A program for managing personal finances ought to be as simple and clear as possible. The Grisbi financial manager promises simplicity but doesn't support online banking.