Can I restrict the number of entries

[KJM96]

Creating an enrollment database. Can I set it up so that a message will
indicate class is filled when it reaches a set number of enrollments?

 

[Jeff Boyce]

So you don't care to have a "waiting list", in case one of the enrollees
isn't able to attend?

One approach to limiting enrollment in a class would be to store the class
"capacity" in the record for that class.

"How" really depends on "what" ... what data structure are you using?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Paul Shapiro]

One possibility is to enforce the limit by choosing your primary key for the
enrollment table. If all classes have the same enrollment limit, you could
choose your primary key as the combination of classID,
registrationSequenceNumber. Put a validation rule on
registrationSequenceNumber for something like Between 1 and 29.

But if each class has a different enrollment limit, then you would have to
add the enrollmentLimit as an attribute in the Class table and enforce the
constraint with VBA code in your data entry form.