How do I pass information tied to dropdown Field

This is in FrontPage 2003

I have a form set up that the user selects a unique ID from a dropdown based
on a database.

Using this same database ID, I want the Confirmation page to show this ID as
well as additional fields from the database that are tied to this ID.

This ID and other information being input in the initial form are being sent
to a second database.

An example the user is inputting First Name - Last name - selecting a class
ID form a dropdown list and clicking submit.

When the confirmation page comes up, I want the user to see the class
information as well as his/her name.

I am really stuck.

Dave

Some more info!

In my code I have only one value listed and that is for the CID. How do I
pass a value for CLASS which is A+ and the DATE which is June 6th.

Or how do I display the database results tied to the CID? Either way would
give me what I want.

Thanks

Dave

"Skydolphin" <Skydolphins@hotmail.com> wrote in message
news:E59CB62C-A748-499B-B5CE-9FD332E1F429@microsoft.com...
> There are several different ways to do this. Assuming you are using an
ASP page the easiest way is this. In your form tag make sure you have the
action=address of the confirmation page and method=post. Then in the ASP
script in the confirmation page you can set variables equal to the posted
values from the form page. Something like:
>
>
> <form id="myform" action="confirm.asp" method="post"><input type="text"
name="student"><select size="1" name="CID"><option
value="1">1</option><option value="2">2</option></select></form>
>
> in the confirm page, get the values passed in from the form page.
> <%
> classId = request.form("CID")
> studentName = request.form("student")
> %>
>
> Be sure the values inside the quotes match the names of the form fields
from the form page.
>
> Does that make sense?
>
> Rhonda

This makes sense, but here is the catch unless I am missing your point.

To make this simple for my poor brain.

The student inputs his/her NAME. Then uses the drop down to choose A+ on
June 6th which is being fed from a database. Tied to this record is CID 7.

On the confirmation page I get "7", and the student NAME, but not A+ on June
6th.

The CID is being fed, but not the A+ or June 6th.

I tried a Results Wizard and I can show all the classes, but if I try to tie
the results to the CID, I get the yellow error the wizard generates.
Am I missing the point?

Thanks for writing!!!

Dave

"Skydolphin" <Skydolphins@hotmail.com> wrote in message
news:E59CB62C-A748-499B-B5CE-9FD332E1F429@microsoft.com...
> There are several different ways to do this. Assuming you are using an
ASP page the easiest way is this. In your form tag make sure you have the
action=address of the confirmation page and method=post. Then in the ASP
script in the confirmation page you can set variables equal to the posted
values from the form page. Something like:
>
>
> <form id="myform" action="confirm.asp" method="post"><input type="text"
name="student"><select size="1" name="CID"><option
value="1">1</option><option value="2">2</option></select></form>
>
> in the confirm page, get the values passed in from the form page.
> <%
> classId = request.form("CID")
> studentName = request.form("student")
> %>
>
> Be sure the values inside the quotes match the names of the form fields
from the form page.
>
> Does that make sense?
>
> Rhonda

Can you send me a copy of your code so I can see what you are doing? You can change the names of the DB and stuff for this purpose

Rhonda

Do you want the entire asp pages or cut and paste the code?

Thanks

Dave


"Skydolphin" <Skydolphins@hotmail.com> wrote in message
news:0EC66751-52AD-419F-B055-FE40002D41BA@microsoft.com...
> Can you send me a copy of your code so I can see what you are doing? You
can change the names of the DB and stuff for this purpose.
>
> Rhonda

This is one place that I think another value needs to be added.

<!--webbot bot="DatabaseRegionStart" endspan i-CheckSum="47620" --><select
NAME="ClassID" SIZE="1">

<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn1.inc"
startspan --><!--#include file="_fpclass/fpdbrgn1.inc"-->

<!--webbot bot="AspInclude" endspan i-CheckSum="5346" -->

<option
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"><%=FP_FieldHTML(fp_rs,"Class")%> 
  <%=FP_FieldHTML(fp_rs,"Date")%>

</option>

"Skydolphin" <Skydolphins@hotmail.com> wrote in message
news:0EC66751-52AD-419F-B055-FE40002D41BA@microsoft.com...
> Can you send me a copy of your code so I can see what you are doing? You
can change the names of the DB and stuff for this purpose.
>
> Rhonda