Quote:
Originally Posted by edslunch
It seems like you really have a two part key - month and make. If you want a single id field for a record that contains both make and month then just use an auto generated ID that will be 1 to 5 in his case and will be essentially meaningless, just unique across all records. If you want to be more sophisticated create a make table and a month table then a make and model table that has foreign keys to the other tables.
|
Agreed. I was a little confused reading the question and so only answered the autonumbering part. A better model (aside from having two tables) would be to have make in one column and month in another.