|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 11th, 2009, 04:28 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Linking Supervisor's to designated employee's to training
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 
|
|
#2
June 11th, 2009, 05:23 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Linking Supervisor's to designated employee's to training
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 "Fly Boy 5" wrote in message ... 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
|
|
#3
June 11th, 2009, 10:12 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Linking Supervisor's to designated employee's to training
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 "Fly Boy 5" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
