Re: SUM IF totals help

[Andrew Adcock]

laptop alias Wrote:
------------------------------------------------------
> normalized schema. In this
> case that would probably mean a separate table
> with a row for each
> budget_goal_id/select_year/select_month combo.
> E.g.:
> 5, 2010, 01
> 5, 2010, 02
> 5, 2010, 03
> 5, 2010, 04
> 5, 2010, 05

I am sorry for my ignorance laptop alias, but I am not understanding how this table would look.

First, is it a lookup table? Or merely a container to hold values. I assumed that it was the latter but then I could not figure out what my fields would be? maybe one primary key like 'months_id' which is an auto increment (but maybe this field would be overkill?) and then a field for the budget_goal_id which is the foreign key - then once last field that is the concatenation of the year and the month (I suppose I could save this in a DATE field and just always make the day 01?)
Does that sound right??