I need to set up an employee training database. I have the tables: Employees , Training Modules , and a table of courses.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Employee Table - Lists the Training Modules required

Training Module Table - Lists the Training Courses Required

Course Table - Lists the topic to be covered in each training

I would like to relate them.  For example, Employee 1 has train in modules A & C.  Modules A & C have training courses X, Y, & Z.
Photo of Brian

Brian

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,924 Points 20k badge 2x thumb
What is your question?
Photo of Brian

Brian

  • 0 Points
I would like to be able to relate the tables.  I have called QB customer support and they failed.  Simple task really.  I have 12 employees.  Each employee has required training modules.  Each training modules has specific courses.  Each course has specif requirements and periodicity to training/renewal.  I would like to track progress.  See what training is incomplete, what training is coming due, what employees are complete, etc....
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,924 Points 20k badge 2x thumb
Call them back - this is an elementary task unless there is some information you are not providing.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
i think that Brian is asking for some suggestions as to how to build the "Many to Many" relationships required to make this work.  I will chime in later when I get a chance.
Photo of Brian

Brian

  • 0 Points
I have a support ticket in.  I have had no response.  The help desk technicians are weak.   I too realize this is simple task.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
I believe that these are the relationships required.  i will use the convention One < Many

1 EE < Training Modules Required (EETMR) > Training Modules (TM).  (ie the Traiing Modules Required is the many to many join table.


1 TM < Courses (ie a training module has several courses in that education module.

1 EETMR < EE Courses Taken (EECT) > Courses

An EETMR will be flagged as completed when the Summary field of the # of EECT = # EECT with a passing grade.  ie,one assumes that the E has to show up for the course and either pass, or at least attend.

An EE will he considered to be all Trained and in compliance if Summary field of the # of EETMR = # EETMR where the EETMR is flagged as completed.  (ie they have completed all their scheduled Training Modules).

If the Training modules have some expiry date, like the CPR training is only good for 3 years, then that could be a field on the EECT, such that it expires and fall back into an expired incomplete status, thus putting the EE into a warning condition.  The EE could be flagged as having EETMR which are due to expire so managers can plan to have them recertified before they expire.

You may contact me via the information in my profile if you would like one on one assistance to set this up or you may continue the discussion here and i will help as my time allows.