I hope someone out there can help us. The situation is that we have two tables with the fields indicated.
Table1:
Emply_ID
Employee_Name
Employee_section
Table2:
Emply_ID
Training_Class
Training_Date
Comments
On form #1, we would like to:
...(1)Select the section that training was given to(this we can do via dropdown list)
...(2)Enter the date the training was done
...(3)Select the name of the class taken(this we can do via dropdown list)
...(4)Click the continue button and open a form(s) for each member of the section, with the dates and class already entered.
This would enable us to indicate in the comments why someone did not make the class, or any other comments needed, as well as make one entry for the entire section.
How can this be done?
Thanks.
Harry Jessen
HMJessen@Yahoo.com
Table1:
Emply_ID
Employee_Name
Employee_section
Table2:
Emply_ID
Training_Class
Training_Date
Comments
On form #1, we would like to:
...(1)Select the section that training was given to(this we can do via dropdown list)
...(2)Enter the date the training was done
...(3)Select the name of the class taken(this we can do via dropdown list)
...(4)Click the continue button and open a form(s) for each member of the section, with the dates and class already entered.
This would enable us to indicate in the comments why someone did not make the class, or any other comments needed, as well as make one entry for the entire section.
How can this be done?
Thanks.
Harry Jessen
HMJessen@Yahoo.com