M
MikeB
Perhaps some of the more experienced members here can advise me on my
thinking about my database design.
I manage a school chess club. Every year the kids sign up. Each year
we gaterh some information - how they go home after chess, who their
teacher is, parents' contact info, whether the parent can volunteer,
whether the kid may play in chess tournaments, whether the parent can
transport the kid(s) to tournaments, etc., etc.
The questions, and of course, the answers are not the same each year.
So I'm thinking of splitting my Players database into two or more
tables. Currently I'm thinking of a main Players table that contains
the "static" information about each player - their name, rating,
level, etc. and then a (for instance) Player2008 table that contains
the variable data for school year 2008. THen next year I can create a
Player2009 table for the variable data for that year. On the Player
form, I can then build a tabbed control and label each tab for a
school year and display the relevant data for that year.
Is this how others would do this? It still seems cumbersome, but I
can't think of an alternative.
Thank you
thinking about my database design.
I manage a school chess club. Every year the kids sign up. Each year
we gaterh some information - how they go home after chess, who their
teacher is, parents' contact info, whether the parent can volunteer,
whether the kid may play in chess tournaments, whether the parent can
transport the kid(s) to tournaments, etc., etc.
The questions, and of course, the answers are not the same each year.
So I'm thinking of splitting my Players database into two or more
tables. Currently I'm thinking of a main Players table that contains
the "static" information about each player - their name, rating,
level, etc. and then a (for instance) Player2008 table that contains
the variable data for school year 2008. THen next year I can create a
Player2009 table for the variable data for that year. On the Player
form, I can then build a tabbed control and label each tab for a
school year and display the relevant data for that year.
Is this how others would do this? It still seems cumbersome, but I
can't think of an alternative.
Thank you