Suggestion on table design

Hi,

I have a small database for storing workplan of aroung 40 partners..

The speadsheet look like the following

No Main Activities June W1 June W2 June W3 June W4
July W1 July W2 July W3 Juky W4


Among the main activites, I have Activity category that work as a header of
a group of activity.


My problem is how do I design table to accomodate the scheduling week (eg
June W1 June W2 June W3 June W4 July W1 July W2 July W3
....)

Would the table structure below good enough for the said condition above?

tblActivity
ActivityID PK Auto Number
Activity_Name Text

tblActivityDetail
ActivityDetailID PK Auto Number
ActivyID FK
ActivityDetailName Text
ActivityComment Text

tblActivitySchedule
SchedukleID PK Auto Number
ActivityDeatailID FK Number
ActivytyScheduleID Number

lookupScheduleTable

ScheduleID PK Auto Number
Schedule Name text = June W1 June W2 June W3 ....=
need to find a quick way to fill table with week of the month for each given
year


SF

How are you determining what the column headers should be? As an example, if
the month begins on a Wed, is that week June W5 or is it July W1?

----
Dale



"SF" wrote:

Hi,

I have a small database for storing workplan of aroung 40 partners..

The speadsheet look like the following

No Main Activities June W1 June W2 June W3 June W4
July W1 July W2 July W3 Juky W4


Among the main activites, I have Activity category that work as a header of
a group of activity.


My problem is how do I design table to accomodate the scheduling week (eg
June W1 June W2 June W3 June W4 July W1 July W2 July W3
....)

Would the table structure below good enough for the said condition above?

tblActivity
ActivityID PK Auto Number
Activity_Name Text

tblActivityDetail
ActivityDetailID PK Auto Number
ActivyID FK
ActivityDetailName Text
ActivityComment Text

tblActivitySchedule
SchedukleID PK Auto Number
ActivityDeatailID FK Number
ActivytyScheduleID Number

lookupScheduleTable

ScheduleID PK Auto Number
Schedule Name text = June W1 June W2 June W3 ....=
need to find a quick way to fill table with week of the month for each given
year


SF

Hello SF,

I noticed that nobody answered.

In essence, you just posted an attempted answer instead of the needed facts
of the question.

You are going to have to describe the real-world situation and entities that
you want to database.

Hope that helps a little.

Fred

Dale thank you for your input. I want the header to display July W1.

I am also concern that report from crosstab may not have the exact column
name for each schedule.

SF

"Dale Fye" wrote in message
...
How are you determining what the column headers should be? As an example,
if
the month begins on a Wed, is that week June W5 or is it July W1?

----
Dale



"SF" wrote:

Hi,

I have a small database for storing workplan of aroung 40 partners..

The speadsheet look like the following

No Main Activities June W1 June W2 June W3 June W4
July W1 July W2 July W3 Juky W4


Among the main activites, I have Activity category that work as a header
of
a group of activity.


My problem is how do I design table to accomodate the scheduling week (eg
June W1 June W2 June W3 June W4 July W1 July W2 July W3
....)

Would the table structure below good enough for the said condition above?

tblActivity
ActivityID PK Auto Number
Activity_Name Text

tblActivityDetail
ActivityDetailID PK Auto Number
ActivyID FK
ActivityDetailName Text
ActivityComment Text

tblActivitySchedule
SchedukleID PK Auto Number
ActivityDeatailID FK Number
ActivytyScheduleID Number

lookupScheduleTable

ScheduleID PK Auto Number
Schedule Name text = June W1 June W2 June W3 ....=
need to find a quick way to fill table with week of the month for each
given
year


SF