|
| 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
November 25th, 2008, 10:05 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
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
November 25th, 2008, 01:54 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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 | |
|
|
Linear Mode
