How to achieve sequential record viewing one at a time ?

[recyan]

The Scenario

Many Exercises
Each Exercise will have many sub-exercises
Each Sub-Exercise will have many words
A word may belong to the one or many Sub-Exercises

Currently, the tentative tables :

tblExercises
ExerciseID - PK
Exercise

tblSubExercises
SubExerciseID - PK
SubExercise
ExerciseID - FK

tblWords


WordID - PK
Word

tblSubExerciseWords
SubExerciseWordsID - PK
SubExerciseID - FK
WordID - FK

Some thoughts on how to achieve below required :

I should be able to go to the Exercise & SubExercises & the words in the SubExercise in a sequential manner, one by one.

Ideally, I should go to a screen which displays the first word in the 1st SubExercise in the 1st Exercise at the start.

There should be a button on the screen, which when clicked, will take me to the next word in that SubExercise.

Once all the words from the 1st SubExercise are finished, the clicking action of the button should take me to the next SubExercise, if it exists & hence to the 1st word in the 2nd SubExercise & the process repeats.

If there are no SubExercise left in that Exercise, then clicking the button should take me to the next Exercise & then to the SubExercise in the next Exercise & so on.

In addition to the NEXT button, I should have a PREVIOUS button, which will take me to the previous word viewed, if the need arises.
Thanks

[June7]

Sounds like a lot of VBA coding in your future. Probably will need global variable to keep track of 'last' record ID read with each button click.

[A S MANN]

I think
the table ineed minor corrections

tblSubExerciseWords
SubExerciseID - PK
WordID - PK
You connect these table by relationship on blank table ( Without data)

tblExercises 1 >>>Many tblSubExercises 1 >>> Many tblSubExerciseWords Many >>> 1 tblWords
Than Create a form to show your data as need. Navigation are done through command buttons. Subform can be used to show table data.
Hope that will solve your issue.
A S MANN

[recyan]

Sounds like a lot of VBA coding in your future.

That exactly is what I was trying to avoid. Appears like I'll have to bite the bullet.

I think
the table ineed minor corrections

tblSubExerciseWords
SubExerciseID - PK
WordID - PK

Sorry, Forgot to mention that SubExerciseID & WordID together make up the Primary Key and am using pseudo-key in their place.

You connect these table by relationship on blank table ( Without data)

Was not able to understand this. Can you elaborate, please ?
[EDIT] Realized, we are talking about establishing the relationships between the various tables in the relationship window.[/EDIT]

tblExercises 1 >>>Many tblSubExercises 1 >>> Many tblSubExerciseWords Many >>> 1 tblWords
Than Create a form to show your data as need. Navigation are done through command buttons. Subform can be used to show table data.

Basically, I am not looking at a form - sub-form arrangement. Only one relevant word needs to be displayed on the screen, with the option of moving on to the next word or the previous word.
A somewhat parallel example (perhaps this would make, what I am trying to say, clearer) would be,
an online questionaire which has multiple sections & sub-sections, with one or many questions in each sub-section,
where you are presented one question at a time
and you have the option of moving to the next question
or going back to the previous question.

- boy, i sure made a mess of posting my question earlier in the 1st post.

Thanks

[A S MANN]

The form can be created quite easyly and can be cutomised as per need . It will show you one record if you wish.
A S MANN

[recyan]

Am not much in to forms. I'll have a go at what you are suggesting & see how it goes.
Do you think using the Form wizard will be useful or do I need to go beyond that ?

Thanks

[A S MANN]

The form Wizard can create a simple form but to customize it you need to go to it's design. You first create the relationship, Feed data and try to create a simple form .
A S MANN

[recyan]

Hi,

Thanks for the inputs. Will have a go.

Thanks

[orange]

For clarity, is this the question?? still a little cloudy....
You want to select a word from a list of unique words, and see which subexercise/exercise the word appears in?

[recyan]

Exercise1
    SubExercise1
        Word1
        Word2
        Word3
        Word4
    SubExercise2
        Word1
    SubExercise3
        Word5
        Word6
Exercise2
    SubExercise1
        Word7
        Word8
        Word2
    SubExercise2
        Word9
        Word10
    SubExercise3
        Word11
Exercise3
    SubExercise1
        Word12
Exercise4
    SubExercise1
        Word1
        Word2
Exercise5    
    SubExercise1
        Word4 

The opening screen will show Word1 of Exercise1->SubExercise1
On clicking a NEXT button,
it will show Word2 of Exercise1->SubExercise1 & so on sequentially, on each click of the next button.
till it reaches the last word Word4 in Exercise5->SubExercise1.

Sorry for the lack of clarity, it's just that, I have some vague thoughts in my head ( idle mind ), that I am trying to give shape and there's more to it than what I currently am speaking about.
Currently, am just bouncing the ball to see, how it goes.
Most probably, I might have to go for an interactive browser application with html, front-end, backend db, javascript or ajax.

Thanks.