Entering Overtime Information For Employees Weekly

[MFS]

Good morning everyone,
Here is what I am trying to do, I have roughly 30 employees that report to me and weekly I would like to open my database and enter the hours of worked overtime for the current week ending on a form for each of those employees, by going down the list.
How can this be done? When I open my form now I see all my employees but also the hours they worked that were recorded from the previous week. Obviosuly if I change the week ending date and the hours worked it over writes what was entered the week before.


I hope someone can help me with this.

Speck

[John_G]

Could you not just create a new record for the current week for that employee? You would be doing that anyway for all of them, and when you create those records doesn't really matter.

[MFS]

What I would like is to open a form that is populated with all of my employees where I need to enter "week ending" and their "OT hours" once a week

[John_G]

Do you have a separate record for each employee for each week? If not, you should, otherwise you have no way of tracking the past data.

You really have a one-to-many relationship here, requiring two tables. You would have one table for the main employee data, and a second one to record the hours worked each week for each employee. The week-ending date would be in that second table.