timesheet form

[Peter]

Hello,

Read all the 8 pages on "timesheet" search. It changed the way I want to setup my database. I try to make a database which includes a weekly timesheet (mo - fr).
Due to normalisation, the table will only contain:
employee id - project number - date - hours - - activity

The (sub?) form however should show a selction based on employee id and weeknumber of this table.

How do I get a form which shows like a sheet:
project number - project discription - activity - mo - tu - we - th - fr
It should be possible to add rows in the form.

I'm on access 2007.
Any help appriciated.

 

[marianne]

that is still ineffective normalization i think, because you are duplicating part of your records in table 1 to table 2 thru your subform base on your main form.

I guess there is no need to specify whether monday, tuesday wednesday etcetera since a coding will make that for you, especially you have already indicated your date in table 1.

you should rather ask for the coding to extract whether the date in table1 is monday or tuesday or whatever. that way, you will less consume space in your db.