Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Limiting number of inputs (2003)

    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

  2. #2
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limiting number of inputs (2003)

    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.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Limiting number of inputs (2003)

    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
    Jerry

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Limiting number of inputs (2003)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •