Add multiple records to a tbl from one form

[DougB]

I am a rank beginner working on an already created db that my section uses to track payroll hours. The Hours Entry Form allows the Admin Spec to enter the empl ID#, Date, Shift Code (identifies kind of work being done), KOT (Kind of Time, i.e. straight time, overtime, sick leave, vacation leave, etc.), and number of hours. On any given day you may need to make four or more entries to record the employee's hours...maybe two different kinds of straight time and two different kinds of overtime. So it become tedious to have to make each entry seperatelt, clear the form and start again. I would like to quadruple (at least) the number of Shift Code, KOT and Hours fields, but leave just one empl ID and date field and be able to create four separate records in the Hours tbl for a single employee. I hope I have explained this clearly. I actually have already copied the additional fields and redesigned the form in design view in a test copy of the db. That was the easy part. But I can't see what I need to do to accomplish my goal. In fact, any entry I make in the original fields immediately appears in the copied fields, so they're apparently not even separate entities yet.

 

[Elvaar]

Doug is there a separate table for the Employees? If so I would suggest a form/subform structure to handle your issue. The Main form would be based on the [employee] table and the subform would be based on the [shifts] table.


HTH,
Bill