workplan table ?

[SF]

Hi,

I have a small db for my project. I have a project table (tblProject with
ProjectID, ProjectName, Location...). I want to incorporation each project
worlplan with project table but I don't agree myself with the structure.
Normally, the workplan is having format below

Project Name: XXXXXXXXXXXX

JANUARY FEBRUARY
Activity W1 W2 W3 W4 W1 W2 W3`W4

Monthly meeting x x
Field Visit x
x
..... ... ...

I would appreciate if someone could advice on the table straucture.

SF

 

[Tom van Stiphout]

Rather than weeknumbers I might want to work with dates. Dates can be
converted to weeknumbers on the fly:
?format$(Date,"yyyy-ww")
2008-48

tblActivity
ActivityID PK
ActivityName UIDX

tblWorkplan
WorkDate PK
ActivityID PK
ProjectID PK

If workplan is a FK in several other tables, you may want to do a
surrogate key WorkplanID auto PK, and then have a UIDX over the three
fields shown.

-Tom.
Microsoft Access MVP