Hi,
I hope somebody can help me. I am designing a database that keeps track of training clases that employees have taken.
I have a table called "Training completed" to keep track of the classes taken. This table has the fields Training# (autonumber), Emp_ID, Course number (this is the course that they just completed) , and Datecompleted.
Here is my problem. It is possible that 200 people can take the same class on the same day. In order for me to enter this data I would have to enter it for the same clss 200 separate times. Is there some way for me to just enter the Course#, DateCompleted once on a form and then enter all the emp_Num's that took that class and have it populate the table that way. Also remeber I have Training# which is a autonumber and the primary key of the table.
Thanks in Advance,
Ryan
I hope somebody can help me. I am designing a database that keeps track of training clases that employees have taken.
I have a table called "Training completed" to keep track of the classes taken. This table has the fields Training# (autonumber), Emp_ID, Course number (this is the course that they just completed) , and Datecompleted.
Here is my problem. It is possible that 200 people can take the same class on the same day. In order for me to enter this data I would have to enter it for the same clss 200 separate times. Is there some way for me to just enter the Course#, DateCompleted once on a form and then enter all the emp_Num's that took that class and have it populate the table that way. Also remeber I have Training# which is a autonumber and the primary key of the table.
Thanks in Advance,
Ryan
