I've created two tables. One table (Classes) stores data about classes
that we offer. The Classes table stores the class id (classid) and the
max number of students allows (maxstudents). The other table
(Students) stores student data and the class they register for.
When a user registers for a class, the classid column data from Classes
populates the class column in Students.
I'm not sure how to count the number of students who registered for
course X, subtract that from the max number of students in the Classes
table, and display that the class if the max is reached either in a
warning dialog box or as text on the page.
I'm also populating a drop-down field on the registration form with the
class information from Classes. Confused yet?
I don't know much about SQL or .ASP. Any help is appreciated.