DGagnon819
Registered User.
- Local time
- Today, 14:37
- Joined
- Jun 17, 2006
- Messages
- 13
Good Morning,
I'm hoping that someone here, who's knowledgable, can assist me in solving this problem. The problem I'm having is that I need to be able to report training events that have and have not been completed.
I'm working on a training database that is to be used at my work place and I'm attempting to design it so that it will manage training events that pertain to everyone and events that only pertain to certain job specialties. I've attached a file which shows the tables.
In the table named TrainingEventInfo information about the event is entered. From the table you can see that there is a JobCode and a ProjectMandatoryCode. A default value is entered for ProjectMandatoryCode if the user is entering an event and selects an option button. If the user selects the other option button then a combo box becomes available and they can select a code from a list. The training event is matched up with the appropriate code and saved to the table. So, there are events in this table which apply to everyone (ProjectMandatoryCode) and then there are events that apply to individuals based on their specialty (JobCode).
In another table named CompletedTrainingRecord, events are matched up with the employee's ClockNumber and a date is put against the event.
Also, from the relationships it can be seen that the ProjectMandatoryCode is in the EmployeeInfo table and is applied to every record by a default value everytime a new record is created.
By looking at the relationships do they look ok? I can't seem to develop a query that will pull all events from the TrainingEventInfo table and where there is a record in the CompletedTrainingRecord table output the DateCompleted. So, I need a report that will produce an entire list of required training and then where appropriate show the date the employee completed the event.
I hope this makes sense. To anyone who can enlighten me I want to thank in advance. I've looked at this for a week and my head is hurting.
Dale Gagnon
I'm hoping that someone here, who's knowledgable, can assist me in solving this problem. The problem I'm having is that I need to be able to report training events that have and have not been completed.
I'm working on a training database that is to be used at my work place and I'm attempting to design it so that it will manage training events that pertain to everyone and events that only pertain to certain job specialties. I've attached a file which shows the tables.
In the table named TrainingEventInfo information about the event is entered. From the table you can see that there is a JobCode and a ProjectMandatoryCode. A default value is entered for ProjectMandatoryCode if the user is entering an event and selects an option button. If the user selects the other option button then a combo box becomes available and they can select a code from a list. The training event is matched up with the appropriate code and saved to the table. So, there are events in this table which apply to everyone (ProjectMandatoryCode) and then there are events that apply to individuals based on their specialty (JobCode).
In another table named CompletedTrainingRecord, events are matched up with the employee's ClockNumber and a date is put against the event.
Also, from the relationships it can be seen that the ProjectMandatoryCode is in the EmployeeInfo table and is applied to every record by a default value everytime a new record is created.
By looking at the relationships do they look ok? I can't seem to develop a query that will pull all events from the TrainingEventInfo table and where there is a record in the CompletedTrainingRecord table output the DateCompleted. So, I need a report that will produce an entire list of required training and then where appropriate show the date the employee completed the event.
I hope this makes sense. To anyone who can enlighten me I want to thank in advance. I've looked at this for a week and my head is hurting.
Dale Gagnon
