I am building a db in Access 2010 to track sales and budgets for a multi-unit business. The business runs on a fiscal year that includes 12 periods consisting of 4-5 weeks each (not close to regular calendar months etc)
I have a calendar table of Date, Week, Period, FY
Sales at each unit are recorded by date. Table: SaleDate, Unit, Sales
Annual budgets are by period, then divided by #of weeks in period. Sales vs budget comparisons are only done by week and period.
How do I set up a Budget table? The fields needed are FY, Per, Week, Unit, Budget, but this provides no primary key. An auto number key won't relate to the other tables. I'm stumped. Any help would be appreciated.