I've built a training tool/quiz, but I'd like to be able to offer the administrator a way to change the sequence of how the pages are displayed. Currently, the fields look like this:

ID
PageTitle
PageContent
QuestionText
QuestionType (radio or checkbox)
AnswerA
AnswerB
AnswerC
AnswerD
CorrectAnswers

How do I do this? If the explanation is too lengthy for this forum, maybe someone can provide a link to a tutorial? Any help would be greatly appreciated.

__________________________________________________ _____________

Confidence is what you feel when you do not truly understand the situation.

__________________
__________________________________________________ _____________

Confidence is what you feel when you do not truly understand the situation.

hello,

  Can u post it clearly what u need?

Hi abq23,

You mean the displaying the questions in sequence that you wish... ?

Say if you have 5 questions, then that can be ordered in any sequence you wish, something like 12345 or 34215 or 43521 ... ???

Is this what you are looking for?

Cheers!

_________________________
- Vijay G
Strive for Perfection

The admin screen I've developed allows the admin to add:

1. The page title
2. The text content of the page
3. A quiz question
4. The ability to identify whether the quiz should display as checkboxes or radio buttons
5. The ability to add up to 10 possible answers
6. The ability to identify which answer is correct.

Once the is saved, this recordset constitutes one "page" in the training presentation. What I'd like to be able to do is allow the admin (perhaps through a separate admin form) to change the sequence of how the pages are displayed. In other words, if she decides that the presentation would flow better if Page #7 followed Page #3, how do I create that sort of capability?

__________________________________________________ _____________

Confidence is what you feel when you do not truly understand the situation.

Hi there,

You can add another column to that table say "DisplaySequence" which is capable of storing numbers in it.

In addition to you list add another "7. The ability to sort the pages in a required sequence." for the admin. Then list all the PageTitles/Quiz and a textbox besides each on a page and let the administrator enter the numbers in each textbox on what sequence it got to be displayed and update the DisplaySequence column for relavant rows.

When the quiz/page titles are selected from the table, sort that by the DISPLAYSEQUENCE column in ascending order.

Select * from TABLENAME order by DISPLAYSEQUENCE asc

This should help you achieve that.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Yet another case of me making this far more difficult than it needs to be... :)

That will certainly work for this particular version. Thanks for your help.

__________________________________________________ _____________

Confidence is what you feel when you do not truly understand the situation.