Edit Update
Corrected some typos
I will if possible add “explained” as a prefix to the thread title.
I must be missing something that should be obvious.
I seem to be seeing way more records in the query than I expect.
The guides & file are all sourced from or linked directly from the Document Foundation site.
It might help if I knew I had database file that definitely matched the tutorial.
I am a complete newbie to Base but I have previously used other database programs without issues.
This is slightly dated, as I note the v4.2 guide only covers flat not relational databases. I have briefly read the LibO & Base guides but am still rather baffled by the tutorial.
The tutorial may well have diverged and been modified over time, that hardly helps, but I seem unable to locate any better copy.
If I open the tutorial database and use tables I see tables including “Vacations”, “Payment type” & “Fuel” with no filter applied I look at the data and the first two tables have only 2 or 3 records. The Fuel Table has 8. (These may not agree with the tutorial figures and oddly have identical odometer readings, unrealistic & unexpected but no matter )
Using Tools → Relationships I discover a 1:n relationship on Date between Vacations:Fuel Tables
Now is where I start to have a problem following what is happening.
I look at Queries
Queries → End-Readings This has 8 records as expected.
Queries → Fuel Economy This has 56 records I do not understand that.
I wonder if anyone is able to help by explaining what is going on here, and maybe even has the correct file that matches the tutorial.
I am using Base 4.2, looking at Chapter 8 of the Libre Office Getting Started Guide for LibO v4.0 and the tutorial file linked from the Document Foundation
- listing: (https://wiki.documentfoundation.org/Documentation/Publications) with file links
- Guide Chapter8
- Tutorial list & link to Automobile.odb
I an using Windows 7 at the moment. I also have Ubuntu 12.04 & 14.04 on this machine, not sure which LibO versions they currently use.