workplan table ?

  • Thread starter Thread starter SF
  • Start date Start date
S

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
 
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
 
Back
Top