Dynamically updating a page through form input.

[Evan145]

Hi guys,
Im a beginner in ASP and looking for help on how to create an
updating page through a selection in a form. A second menu is
displayed depending on the content of the first menu.

ok,
When the page loads there will be a single form menu with a
YES/No/Null option. This will be set from a datbase query.

This is what im hoping to code.
The page loads, runs its query and enters the value in the form

1)IF option is NULL(blank) - a second form is HIDDEN/NOT displayed.

2)IF option is YES - a SECOND dropdown form is displayed with values
from a query from another Db table

3)IF option is NO - a SECOND form dropdown is displayed with values
from a another query from another Db table

NOW, if the user edits the YES/NO form the page redisplays and
the appropriate second dropdown is visible with the required entries.

The values can then be extracted and resubmitted to a new Db table.

***********************************************
|-------------|-----|
|Paid Yes/No? |Blank|-     NO SECOND MENU DISPLAYED
|-------------|-----|V
              | Yes |
              | No  |
              |-----|

***********************************************
|------------|----|     |-------------|------|
|Paid Yes/No?|YES |-    |Payment Type |      |
|------------|----|V    |-------------|------|V
             |No  |                   |Credit|
             |----|                   |Cheque|
                                      |Cash  |
                                      |etc   | 
                                      |------|

***********************************************
|------------|----|     |-------------|------|
|Paid Yes/No?| No |-    |Account      |      |
|------------|----|V    |-------------|------|V
             |Yes |                   |Drop  |
             |----|                   |Warn  |
                                      |Ban   | 
                                      |etc   | 
                                      |------|

The user can THEN RE-EDIT the Paid Yes/No option and its
related form is displayed ready for editing.

I hope this isnt too confusing
Thanks in Advance.

 

[corneI]

Hi

Read the following :

FAQ333-3656

I think it will answer your question?

Corne'
#-)