Dates as Foreign Keys

[reliza123]

I have a bunch of projects with different future predicted status phases. The dates of these phases are stored as foreign keys, that link to a 'date table'. I am trying to create a report that shows the name of each project in each row, a few bits of information like funding and then where the predicted phases land in a table of dates as the column headers (see sample). How do I create this Query so that it runs and pops in the report ?
Thank You.

 

[ranman256]

I would think the tProjects table would NOT be keyed on date, but rather the PROJECT name.
tProjects
========
[Project], [ProjDate],[ProjDescr]
then

tTasks
=========
[TaskID], [Project],[TaskDate],[TaskDescr]

you can join the 2 on Project and print the report sorted by Date

 

[Kyle123]

Using Dates as keys is just plain nasty. However what's the problem that you're actually having? Having a date as a foreign key is odd, but it shouldn't make a difference to the query