Using confirmation fields in a new form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create forms that work as steps of a procedure. on the first
step the user will enter information which is submitted to the database. now
I need to open the second step which is going to edit the same record that
was created on the first step. How can I call that record into the new step?
is it possible to use the confirmation fields for data sent in the last step
as a criteria in the query for the new step. If I can do that then I will be
able to continue adding information to that record until the procedure is
completed.
 
See http://www.w3schools.com/asp/default.asp and http://www.asp101.com/samples/

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I am trying to create forms that work as steps of a procedure. on the first
| step the user will enter information which is submitted to the database. now
| I need to open the second step which is going to edit the same record that
| was created on the first step. How can I call that record into the new step?
| is it possible to use the confirmation fields for data sent in the last step
| as a criteria in the query for the new step. If I can do that then I will be
| able to continue adding information to that record until the procedure is
| completed.
 
Set the action to the next page in line. Let that handle submission to
the database and continue with whatever else is required.
What serverside language you use will depend on what your Provider
supports.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.
 
I am sorry but I am very new to all of this specially asp. If I send the data
from the first page to the second page and let it submitt everything to the
database wouldn't I have the same problem again on the third page and the
next one?
 
Thanks for your reply. there is a lot of information on the links you
provided and since I have no clue on how to do this, I am not sure which
parts of the links really apply to my problem. Can you please be a little
more specific. I really appreciate it.

thanks,
 
What is the logic behind having the form split into steps?

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
It is a very long test procedure that is performed on a test bench. it
involves different tests compiled together in one procedure and each require
a different setup by the tester. so, I need him to complete a test and send
the data in and then move to the next step without having to input all the
general information like the unit serial number, etc...
 
Also, Is it possible to have a form send data to a database and post it to
the next page at the same time? if so, then my problem is solved.
 
The way I would do this using ClassicASP / VBscript is to post the first Step 1 to the database as a
new record with a custom assigned TestID, then on Step 2, retrieve the record via the TestID for
editing, and so on.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
You would write a custom ASP/VBscript to submit Step 1 data to the database and assign the record a
unique Test ID (from another table in the database), then when the person move to Step 2, you look
up the current record by the unique TestID, and load the content into a edit page, then once the
page has been completed, it would be submitted to the database as a update of the current record.
You would repeat this for each Step thereafter.

To get started with the learning process on how to do this, see http://www.asp101.com/samples/

==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
Back
Top