Please help with an online registration--my time is running out!

[cbaskas]

I design my school district's web page using frontpage 2000. I was asked to create an online form to collect student choices for our upcoming "Career Day." Each student is to fill in their last and first name. Then, they are to choose a Career Day speaker (from a drop down menu--doctor, lawyer, web designer, etc.)for each session (there are a total of 6 sessions). Here is my problem: Each speaker for each session can only accomodate 20 students--I need a way to close out the session after 20 students have registered.
This is my first time creating a form like this (with limitations), so please hold my hand.
If there is an easier way...

 

[durug]

You will need to store all the information in a database (ie. Access) and then query it to see if it exceeded the number of maximum registration. And so you could restrict access to the form.

Without a database I can't see other solution.

If you need more help just let me know.

Regards,
Durug

 

[cbaskas]

Thanks so much for your response. I've been trying to get help all week in different forums, but I've had no help...until now? Here is what I've built so far:

http://www.dist126.k12.il.us/prairieweb/speakerregistration_02.asp

The information is dropped in an Access database. Each of the 6 sessions will have about 15 different speaker selections. If 20 kids choose to see the Web Designer during the 1st session, how can I force the 21st student that also wants to hear the Web designer during the first session to choose another speaker from the drop down list.

Tomorrow I will get a list of the speakers and the kids are to do this on Tuesday, 4/23.

I'd appreciate any help you can give me--I really don't want to figure out Career Day schedules for 400 kids. YIKES!

Thanks so much for your time.

Carol

 

[durug]

Let me see if I understood this correctly:
you have 6 sessions. Each sesson can have 4 themes.
On each theme you have 15 candidates(speakers). Right?

And you want that students choose the session and theme. When do you decide which theme and candidate(speaker) "wins"?

Can it be that different seesions can have the same theme and the same speaker?

If already 20 students choose a theme and a candidate dosn't mean that this ession is closed already?

I will be online, just make me understand the problem completely

Regards,
Durug

 

[cbaskas]

There are six sessions (no themes). Each session will have approximately 15 different speakers. Example:
Session #1 (9-9:30 a.m.): Web Designer, Doctor, Lawyer, Firefighter, etc.
Session #2 (9:40-10:10 a.m.): Web Designer, Doctor, Teacher, Pilot, etc.
Session #3: Web Designer, Policeman, Acccountant, Pilot, etc.
Session #4:
Session #5:
Session #6:

There are duplicate speakers, but at different times because some speakers can stay longer than others.

If 20 students register to see the Web Designer during the 1st session, then when student 21 comes along--i want the Web Designer option closed for session one. This, then, will force a student to choose another speaker to see during session #1 BUT that student may see the Web Designer in Session #2 (if it isn't filled).

I don't know how to close it after the 20th student tries to register.

If you know an easier way than drop-down menus (besides doing it by hand)...i'm desperate at this point.

Thanks again--i hope you understand my problem.

 

[durug]

One last question, I promise

What do you mean by "--i want the Web Designer option closed for session one"? You close the session 1 or you close the session1 for web designer?

If 20 students register for session 1 - web designer
that dosn't mean that that's it with session one?
Can different speakers participate for the same session like session1 we have web designer and doctor?
That dosn't mean the students # 21 can choose only session 2, 3 and so on, but not seesion 1?

I really like to help you but first I have to understand the logic

Durug

 

[cbaskas]

If the 21st student chooses to see the Web Designer, he/she should not be allowed to register because all the spots are filled. This does not close the session, just that particular speaker (Web Designer) in that sesssion. Maybe the "Web Designer" choice can disappear or grayed out on the drop-down menu? Now there will only be 14 speakers to choose from in session 1 (instead of 15).

Thanks.

Carol

 

[durug]

If your table is like this:
SessionID, Speaker, Nr_of_Students
you will just have to create this select statement

SELECT *
FROM TableName
WHERE (Nr_of_Students <= 20)
ORDER BY SessionID

This one will populate your comboxoses
Because it will be ordered by SessionID you will just have to have an if statement when the SessionID is changing then create another combobox

Each time when a student submits the form it will update the nr_of_students column.

Does it help you?
If you need more info about the ASP code just let me know.
I'm not going to sleep

Regards,
Durug

 

[cbaskas]

My table is set up like this:
Auto ID, Student Last Name, Student First Name, 1st Period Teacher, Session 1, Session 2, Session 3, Session 4, Session 5, Session 6

I do not have much experience with Access (obviously). Please tell me how I should change my table.

I need to record the First and Last Name of each student so I can give them a print out of their schedule on Career Day.

Thanks!

 

[durug]

I think this table is OK for storing the records for the student
Auto ID, Student Last Name, Student First Name, 1st Period Teacher, Session 1, Session 2, Session 3, Session 4, Session 5, Session 6

And we will need another table like I told you for storing the info about Sessions and available speakers
SessionID, Speaker, Nr_Students. You can populate the table from the beginning like
SessionID Speaker Nr_Students
1 Web Designer 0
1 Lawyer 0
...
6 Web Designer 0
6 Lawyer 0
etc...

When the user presses submit you will
1. insert or update (depends if you find the user already in the first table with the information from the form) records in the first table
2. Update the nr_students column from the second table for drawing back the drop down lists for the next user

That's about it.

It's not hard. but you will still need to create some select, insert or update statements for Access and then put the logic in the ASP page

Hope I was helpful and you can make it.

Regards,
Durug