Just wondering if anyone has any ideas about this?
--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>
> 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