Re: Where to start

Tech-Archive recommends: Speed Up your PC by fixing your registry

Steve,

Sorry for the confusion. I will try to clear it up. My previous reply is
accurate. Here are the examples in lowercase alpha’s.

Project Definition:
1. For each Liturgy (there are 165 fixed and unique names with cycle
designation of A, B, or C). TABLE: LITURGIES
a. Table – LitNumber(PriKey) LitName
1 Advent 1st Sunday A
2 Advent 1st Sunday B
3 Advent 1st Sunday C
4 Advent 2nd Sunday A
5 Advent 2nd Sunday B
6 Advent 2nd Sunday C (Thru 4 Sundays)
7 Easter 2nd Sunday A
8 Easter 2nd Sunday B
9 Easter 2nd Sunday C (etc. thru 165)

2. there will be eleven parts (in each liturgy) TABLE: LITFUNCTIONS
a. Table - LitNumber(PriKey) LitPart
1 Prelude
2 Instrumental Processional
3 Gathering
4 Responsorial Psalm
5 Gospel Acclamation
6 Preparation
7 Pre-Communion Instrumental
8 Communion 1
9 Communion 2
10 Closing
11 Instrumental Postlude

3. and each part will have one song with it’s song number. TABLE: HYMNS
a. Table – HymnID(PriKey) HymnName Hymnumber
1 Morning Has Broken G748
2 Sing to the Mountains G452
3 We Remember G578

Data Input would consist of typing:
1. Liturgy name, eleven parts and the hymns and hymn numbers for each.
a. This would be an example of one data entry ***

Easter 2nd Sunday A
Prelude Healer Of Our Every Ill G854
Instrumental Processional Eye Has Not Seen G616
Gathering Eye Has Not Seen G616
Responsorial Psalm This Is The Day G64
Gospel Acclamation Alleluia, Alleluia, Alleluia G137
Preparation Lord, I Believe G535
Pre-Communion Instrumental Behold The Lamb G824
Communion 1 Behold The Lamb G824
Communion 2 We Remember G578
Closing Glory And Praise To Our God G537
Instrumental Postlude Eye Has Not Seen G616

Query:
1. Select a Liturgy (Liturgies drop down list)
2. View each part of that Liturgy (1 thru 11- one at a time)
3. View each song and song number for each part (can be 4 or 5)
4. Select one song and song number from each part
5. Eleven (11) selected results will be used in a report to be printed
(one song and it's song number from each part)

Report:
1. Print Liturgy name
2. Print each part with the query selected song and song number

I hope this is helpful to fully understand what I hope to accomplish. I
really appreciate your patience with my inexperience. Thanx Steve


"Steve Schapel" wrote:

> Linronamy,
>
> To be honest, I thought your original descriptions were pretty good,
> apart from the confusion caused by changing terminology on me (events,
> actions, and songs, in your first description, became something else later).
>
> Can you give some specific examples of the data you are using? For
> example, some sample data for 'Liturgies'? In the meantime, here is my
> (still incomplete) take on it... If you have 165 Liturgies, and each
> Liturgy can be assigned to one of several Cycles, then the Cycle field
> does not belong in the Liturgies table. There needs to be a separate
> table, related many-to-one with the Liturgies table, to create this
> entity. In my suggested table structure, this is exactly what I did...
> a Liturgies table and a LiturgyEvents table, but you modified this idea
> by collapsing these two tables into one. Then, you named a table in
> your schema as LiturgyEvents, which is actually a different concept, and
> renamed the Action field (which we are now calling LitPart) in the
> HymnAssignment table but in so doing will lose the ability to relate the
> hymn assignment to the Cycle. Mind you, when I look again at your last
> post about 'Data Input', we have lost the aspect about Cycles now, so
> where does that fit in?
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> linronamy wrote:
> > I thought I structured the tables per your suggestion.
> > Please bear with me. I want to understand how I blew it.
> > I suspect my first mistake was in how I didn’t define it properly.
> > There is a liturgy with 11 parts, a song and song number for each part.
> >
> > Project Definition:
> > 1. For each Liturgy (there are 165 unique)
> > 2. there will be eleven parts (in each liturgy),
> > 3. and each part will have one song with it’s song number.
> >
> > Data Input would consist of typing:
> > 1. One Liturgy name
> > 2. Part 1 and its song and song number, Part 2 and its song and song
> > number and so on thru Part 11.
> >
> > Query:
> > 1. Select a Liturgy
> > 2. View each part of that Liturgy (1 thru 11- one at a time)
> > 3. View each song and song number for each part (can be 4 or 5)
> > 4. Select one song and song number from each part
> > 5. Eleven (11) selected results will be used in a report to be printed
> > (one song and it's song number from each part)
> >
> > Report:
> > 1. Print Liturgy name
> > 2. Print each part with the query selected song and song number
> >
> > Trying to do as you suggested helped me recognize I didn’t give you the
> > necessary description to understand what I was trying to do. My apology.
> > Thanks again.
> >
>
.

Quantcast