G
Guest
Access - 2003
I already have two three tables created. One for the Training - tbltraining
and I have TrainingID has the PK. The second table is tblEmployees. The PK
is EmployeeID, and I have another table pertaining to the tblCourse, PK is
obviously Course ID. I have created a form with a subform. The master form
has the employee info, and hopefully the subform will display the training
history.
My problem is that I am trying to do multiple things at one.
1. I am trying to create a macro that will populate the remaining employee
related fields, once I enter in the Training Id - Main form. (Macro design
page) I know how to do it for 5 or 6 record, but for approximately 80
records, it seems I have to enter in information in the condition field 80
times, is there a way to make this process easier.
2. I want to be able to populate the training history form with training
pertaining to whichever employee that is listed in the main form.
MEaning how do I properly link the subform to the main form.
I already have two three tables created. One for the Training - tbltraining
and I have TrainingID has the PK. The second table is tblEmployees. The PK
is EmployeeID, and I have another table pertaining to the tblCourse, PK is
obviously Course ID. I have created a form with a subform. The master form
has the employee info, and hopefully the subform will display the training
history.
My problem is that I am trying to do multiple things at one.
1. I am trying to create a macro that will populate the remaining employee
related fields, once I enter in the Training Id - Main form. (Macro design
page) I know how to do it for 5 or 6 record, but for approximately 80
records, it seems I have to enter in information in the condition field 80
times, is there a way to make this process easier.
2. I want to be able to populate the training history form with training
pertaining to whichever employee that is listed in the main form.
MEaning how do I properly link the subform to the main form.