Linking Supervisor's to designated employee's to training

[Fly Boy 5]

I'm trying to come up with a training progress data base.
I have 3 tables:
Supervisors, Operators and training.

I thougt I could link one supervisor to many operator to many training
sessions.

Any suggestions would be appreciated.

JW

 

[Jeff Boyce]

Insufficient info ...

Telling the table names doesn't let us know what data is being stored (i.e.,
both fieldnames and what is actually stored in the fields).

Don't your 'training sessions' have topics? Where's a table related to
TrainingTopics?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Steve]

Consider using the following tables:

TblSupervisor
SupervisorID
FName
LName
etc

TblOperator
OperatorID
OPFName
OpLName
etc

TblSupervisorOfOperator
SupervisorOfOperatorID
SupervisorID
OperatorID

TblTrainingSubject
TrainingSubjectID
TrainingSubject

TblTrainingSession
TrainingSessionID
TrainingSessionDate
TrainingSubjectID

TblTrainingSessionAttendee
TrainingSessionAttendeeID
TrainingSessionID
OperatorID
DateRegistered
TrainingSessionCompleted (Yes/No)

Steve
(e-mail address removed)

 

[J. Williams]

Try http://accesstrainingdatabase.blogspot.com/. The employee training
database templates here aren't free, but are affordable and easy to use.