Form for multiple records at one time

[rnc110]

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

 

[Lightning]

Use an UpDate query to update the Date Completed field where CourseID = your course number.

Set up a form with textboxes to enter the CourseNo and DateCompleted data, then pass this data to the query's criteria row by using

=Forms![YourFormName].[CourseNo]
=Forms![YourFormName].[DateCompleted]

in the criteria row of the query.

HTH
Lightning

 

[perrymans]

Design will solve your problem. Make a seperate Course table, and an Attended Table (as in employees attended). The course table should have the CourseID (Primary Key)and CourseName and a Description if you wish. The attended table should have the CourseID, EmployeeID, DateAttended. Establish a one-to-many relationship from tblCourse to tblAttended with the CourseID field and enforce referential integrity. Make a query for each table, create seperate forms from each query.

Open your Course form and insert the Attended form as a subform. Just make sure that your attended form is set for "continuous forms" or "datasheet view".

Make the CourseID on the Course form a combo, (do not show the COurseID field on the subform). And set your DateAttended field for a default of Date() and you won't have to enter the date.

So when you open the form, select the CourseID, and just enter only employee numbers in the subform.

Sean.