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.
|