Re: [libreoffice-users] Base/HSQL table with more than two dimensions?

2020-06-24 Thread John Kaufmann
On 2020-06-24 08:40, Dan Lewis wrote: A lectionary is an ordered set of readings, typically using a cycle of three or more years, to cover the Bible. In a four-year cycle the years are simply designated {A,B,C,D}, and for each day in a year readings are prescribed from different parts of

Re: [libreoffice-users] Base/HSQL table with more than two dimensions?

2020-06-24 Thread John Kaufmann
On 2020-06-24 06:39, Dave Howorth wrote: ... It should be possible to do a table of three dimensions, of which the third dimension is the year {A,B,C,D} in the cycle, so that one could compare the readings for any given day across all years. But I don't see how to extend tables into three (as

Re: [libreoffice-users] Base/HSQL table with more than two dimensions?

2020-06-24 Thread Dan Lewis
What I see, you are talking about three tables which contain data: readings, days, and years. A fourth table should be created containing three foreign keys for these three tables. What you need for this data is a relational database which Base can create. Just make sure you normalize these

Re: [libreoffice-users] Base/HSQL table with more than two dimensions?

2020-06-24 Thread Dave Howorth
On Wed, 24 Jun 2020 02:28:45 -0400 John Kaufmann wrote: > A lectionary is an ordered set of readings, typically using a cycle > of three or more years, to cover the Bible. In a four-year cycle the > years are simply designated {A,B,C,D}, and for each day in a year > readings are prescribed from

[libreoffice-users] Base/HSQL table with more than two dimensions?

2020-06-24 Thread John Kaufmann
A lectionary is an ordered set of readings, typically using a cycle of three or more years, to cover the Bible. In a four-year cycle the years are simply designated {A,B,C,D}, and for each day in a year readings are prescribed from different parts of the Bible. For any year, storing the