If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
workplan table ?
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 |
#2
|
|||
|
|||
workplan table ?
On Tue, 25 Nov 2008 17:05:40 +0700, "SF" wrote:
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 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 |
Thread Tools | |
Display Modes | |
|
|