AnsweredAssumed Answered

a design question

Question asked by msadesign on Dec 15, 2010
Latest reply on Jan 12, 2011 by philmodjunk


a design question


I am just starting to storyboard a new solution for my wife's yoga classes, and need some direction on how things are set up. Here is where I think I am headed:

Table 1 would be student records including amounts paid and number of classes purchased

Table 2 would be attendance. The classes never have more than 20 students or so. I thought each record could be dated, and then all current students displayed by way of a check box value list. This way, she can quickly check off all of the students attending a particular class.

Where I am having problems is in getting the data out of the value list above. I need to know for each student what date he attended and then use that data to calculate how many classes are remaining. I don't know how to do that.

I also need to know how many students in a class. To my way of thinking this means counting the number of times that the check box value list has been populated with an X. I don't know how to do this, either.