I need to automatically insert a set of records into a table from a command button. I have a form called Employee Details which contains a tab control. One of the pages on the tab control is called Training dates which contain a subform called Employee Training Subform. This subform contains datasheet of training dates and training name for a employee. This is the query that supports the subform:
SELECT tblEmployeeTraining.TrainingDate, tblEmployeeTraining.CompletedFlag, tblEmployeeTraining.TrainingGroupID, tblEmployeeTraining.EmployeeID, tblTrainingGroup.TrainingGroupName FROM tblEmployeeTraining INNER JOIN tblTrainingGroup ON tblEmployeeTraining.TrainingGroupID=tblTrainingGroup.TrainingGroupID;
I have uploaded a snapshots in a Word document that includes relative table structures and forms to the Needs Assistance folder.
Please review the notes in the document and see what you think.
What I would like to do is add the record for mandatory trainings when I add a new employee reecord. It would contain the employeeID and the traininggroupID and the training date would be null.
THis way I can un a report for employees missing mandatory trainings.
Thank you,
Arthur Lorenzini
Sioux Falls, SD
Tidak ada komentar:
Posting Komentar