My dilemma

[nate]

I am creating a database to enrol children in summer camps. We have multiple camps per week, and have created a form to choose which class they want to be in, however, I would like the class to turn to red, or give some indicator once the maximum number of students is reached.

I have tried to figure it out, but my mind is a blank, anyone have any ideas?

 

[Kryst51]

Well, how do you store how many children a class can have?

 

[nate]

I don't. I just have a master list of the child's details and what different classes they are enrolled in and use a query to separate them.

 

[Kryst51]

OK, your tables are not normalized. I suggest you read up on normalization. Just google it and you'll get lots.

Basically you'll probably want a student table and a class table, the class table can contain such things as the class name, and how many students are allowed to be enrolled. Then you will want a junction table as I assume that many students can be in many classes. The junction table will store the childID and the classID, then build your relationships. Then you can run a query to find out how many students are enrolled in a class, then you can use that along with the class maximum allowed on a form to do a comparison. It's slightly more complicated then how I explained. But read up on normalization first. Then fix your tables and relationships. (Feel free to ask questions along the way.) Then post back if you need more help.

 

[nate]

So, if I'm setting up a class table, I have

Camp names Limit of Students


However, we have 22 different types of camps, some which run some weeks and some which run others. What would be the best way to enter this information? Should I create new fields for each individual week and then mark which of the camps are running?

 

[Kryst51]

That has to do with more normalization... That would suggest another table to handle camps..... Do some serious reading on normalization. And try to figure out how many tables you need.