Fiscal Year Tables and Relationships

[Dorothy]

I need to create several databases for my company. The company runs on a fiscal year broken down into periods and weeks that do not correspond to a normal calendar. (Year begins Sept 28, weeks run Fri-Thurs). All reports need to be run by period and week, so the normal settings of week, month and quarter will not apply.



I am at a loss of how to set up tables and build relationships for this. Do I start with a table of Date, Week, Period, FY? The date is the unique value, so would be the key? Next I need a Forecast table by date and a Sales table by date. Linking tables creates one to one relationships.
Is there a better way to do this?

[recyan]

The company runs on a fiscal year broken down into periods and weeks that do not correspond to a normal calendar. (Year begins Sept 28, weeks run Fri-Thurs).

Till some one comes along, may be wrong, but I believe, at this stage, do not worry about above.

Thanks

[orange]

You may find this article and examples interesting
http://support.microsoft.com/kb/210249