Time Records

[Anuviel]

Ok, still working on my Time project, redesigning and so on.

I have a question about basic table relationship.

I will be tracking time and I am not sure how to set it up. I would most likely like to keep track of in and out as individual records.

Basically it will be run on touch screen computer.

There are four buttons on the layout: In, Out, Break In, Break Out.

Employee hits the appropriate button and a keypad layout opens in a new window, employee punches in their employee code and hits enter. New record is created with their employee id, value for determining if they punched in or out (basic field with In text if they punched in or Out if they punched out) and a timestamp.

That table is related to Employee table via Employee Id.

I do not know how to separate it by week or month. Should I be looking at one more table with dates and relating that to daily table or should I make In and Out as one record for a day and go from there?

Thank you.,