First Database

[pauloc]

Hi
I am a school teacher and am attempting to print out my timetable with each day of the year on a seperate page.
I have created the following tables.
There are relationships between Day in all tables

Date Table
---------------
Date............Day
01/12/2009...M
02/12/2009...T
03/12/2009...W
04/12/2009...TH
05/12/2009...F
06/12/2009...S
07/12/2009...SU
08/12/2009...M
09/12/2009...T

Days Table
---------------
Day....LongDay
M.......Monday
T.......Tuesday
W......Wednesday
TH.....Thursday
F.......Friday
S.......Saturday
SU.....Sunday

Timetable Table
-----------------------

Day...Period...Class
M.....1..........8sc
M.....2..........9Sc
M.....3..........10Sc
T.....1...........8Te
T.....2...........8Sc
T.....3...........9Sc
W....1...........7As
W....2...........8Sc
W....3...........7As
TH...1...........7As
TH...2...........8Sc
TH...3...........10Sc
F.....1...........10Sc
F.....2...........7As
F.....3...........8Sc

Desired Output
---------------------
Monday.......01/12/2009


Period 1.....8Sc
Period 2.....9Sc
Period 3.....10Sc



[New Page]

Tuesday......02/12/2009

Period 1.....8Tw
Period 2.....8Sc
Period 3.....9Sc


Thanks
Paul

[RuralGuy]

You are aware that you do not need the first two tables right? All of that information can be calculated and generated in code.