create registration application that limits number of registrants

Report · Oct 29, 2008

I'm trying to create a registration system with Dreamweaver CS3, an Access database, and using ASP VBscript. I want users to be able to enter their contact info on a form that inputs to an Access DB. I have that part working. On the next page, I want them to choose from ten different dates that a session is held. Each date is limited to 85 attendees. I'm having difficulty figuring out how to capture the number of people who have selected a particular date in Access. The various contact info and the person's selected date are currently entered into a table (registrants). But I don't know how to capture the total number of people who selected a particular date so that I can use that info in DW to either hide a particular date, or show a date for more registations. Is there any way in DW to use a script that will count how many of a like record are in a particular field in a table? If so, how would I do that? Thanks for ANY guidance.

Report · Oct 31, 2008

Hi
I have created similar apps for conferences where each session at the conference is limeted to a certain number of delegates.. The way i did it was to create a query in the AccessDB what Groups the Dates and counts the delegates. You can then use the query in dreamweaver in the same way as tables.. if you think about the results you can use this query (or another) to restrict the options availble to users.. Perhaps write a different query that only returns results if the count is less than the required number and then use this to dynamically drive a drop down list of dates. When a day is full the option will automatically dissapear.. This shoud point you in the right direction. I ended up with loads of hand coded VB script in the end...!