Ask Your Question
0

Explained: Incomprehensible base tutorial (Automobile fuel)

asked 2014-12-31 17:03:00 +0200

John99 gravatar image

updated 2015-01-01 14:25:07 +0200

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

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.

edit retag flag offensive close merge delete

Comments

LibO versions can be seen and copied from Help > About

ROSt52 gravatar imageROSt52 ( 2015-01-01 01:32:22 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-09-06 03:58:44 +0200

paradigm gravatar image

I found amazing help for this in the community. There is an awesome youtube tutorial located at https://www.youtube.com/playlist?list... by TheFrugalComputerGuy

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2014-12-31 17:03:00 +0200

Seen: 3,369 times

Last updated: Sep 06 '18