Append Query out of my league...

[denileigh]

Hi there.

I am trying to create an append query that will update employee time cards for holiday hours without having to enter each time card individually.

* I have an employee table which has the employee id, first name, last name and so on.

* I have a timecard table which holds the employee id, date and time card ID.

* I have a time card hours table which holds the time card detail ID, time card id, work order id, job code id, reg hours, ot hours, holiday hours, etc

* I have a time card expense table which holds the time card expense id, time card id, work order id, inventory item id, cost, total, etc

I need to create a form with a multiselect list containing a list of the employees and a box for the date and for holiday hours. I need to be able to select the employees, enter the date, enter the holiday hours and append it to the time card table AND the time card hours table.

For example I need to append and create new records from the form: the employee id (from the multi-select combo list) and date (txtDate) would pass to the time card table and the holiday hours (txtHours) needs to pass to the time card hours table.

I cannot for the life of me figure this out...it doesn't seem like it should be too hard.

Can anyone help?

 

[denileigh]

Thanks...I already had that one...I was using it for my base. It doesn't create records in multiple tables though and I have no clue how to do that.

I need to create a form with a multiselect list containing a list of the employees and a box for the date and for holiday hours. I need to be able to select the employees, enter the date, enter the holiday hours and append it to the time card table AND the time card hours table.