Fill Table using Another Table

[Sunny Boy 1318]

Greeting People,

I have a question. I have a Table with employees from different departments and I created another form for their daily attendance details.

What i want is - if a director from department x needs to fill in attendance for all his employees, he just select his department from a combo box and all the employees under department x will be listed below and he can update the daily attendance.

This is what i have done so far - I have added a code but here the director will need to select his employees one on one which can be a hassel if he has many employees under his department.

I used below event procedures on date change
Me.TxtLastName.Value = Me.cboOperations.Column(1)

Thanks

Regards,

Sunny

 

[pr2-eugin]

Sunny_Boy_1318,

Why not populate the list of all employee's in a ListBox and then have it to loop over the items in the list.

Few problems to this is. Say for example,

'Tom' takes half day; so the other would have worked for 7.5 hours while 'Tom' would have only 3 hours. How are you going to enter a special condition?

(OR)

'Dick' is on holiday, how will you eliminate his record?

 

[Sunny Boy 1318]

Here is an example of my Table - Let say it consists of a total of 50 employees from 5 different department. I have them listed in a table with other personal information as well...
Dept EmpId LastName FirstName Salary Addresss Phone etc...

My Dept are FIN/ FAC/ OPS/ TRANS/ MGMT, each with 6 employees under them.

I have to add the attendance on a daily basis with some different exceptions and i have many fields to fill in regarding their daily attendance. My Daily Attendance Table have some headings as follows:

Dept EmpId LastName FirstName Date ShiftStatus TimeIn TimeOut Training Briefing etc....

I want to create a form which when i select or type one of the dept, it gives me all the details which i need to fill in the Daily Attendance (Dept/ EmpId/ LastNane/ FirstName) then i can still edit the database and just need to add date and their attendance details. So i will just be getting the details from the employees file and fill in details accordingly the attendance daily.

Hope you got my point here Paul!

 

[spikepl]

You need to start over. Google and assimilate the concept of data normalization. You do not copy data from one table to another. You use queries to assemble existing data as desired.