Limiting number of inputs (2003)

[Caesar3]

I haven't started this project, but I'm trying to mentally figure out how to set up one aspect of it. Suppose you 100 employees, and each employee has to attend a class. The classroom has limited seating

[NYIntensity]

I would use a form (obviously) to schedule the students, with an autonumber to list the student number (1-20)...upon entering the record, I'd use an If statement to check the autonumber...if >20, Error message.

[Jezza]

Various things have to be taken into consideration when designing training/teaching/classroom style databases. The main tables I would think you need:

1) Employees
2) Venue
3) Tutors
4) Courses

This type of database has a realm of many-to-many relationships

a) A tutor can run many courses
[img]/forums/images/smilies/cool.gif[/img] A venue can run many courses
c) A course can have many students
d) A student can have may courses

Personally I always run my forms from queries as a habit and this type of database will have calculations in it.

The course table will probably be the best place to hold the max no of people allowed on the course but this may vary as sometimes a classroom may only hold 15 people so this will have to thought through depending on your needs.

If you have course A the main form can have a text box with the max number of people allowed. The sub form could be a continuous form with a footer showing a list of people attending the course. An unbound text box could be placed in the footer of the this text box which counts the number of people booked. If that count equals the value in the main form, you could have some label that flags up saying "Course Fully booked"

You may have to add a table that shows the courses attended by a student/employee. Think how the db will act if a student is unable to attend a course/ is sick, failed and has to resit etc. my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15> worth

[Caesar3]

Thanks for the <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>!