Creating a table without using wizard

[-id-]

Anyone know how to create a template table so you dont have to individually design each table?
what it is, is:
A database for peoples statistics. each person has a table with each record representing their monthly statistics. I think I will link them to a main table with there names and ID.
Is there a way of usin SQL or VBA to create the tables? Or does anyone have a better DB design?

Ta,
-id-

 

[Rich]

You need to do some research on database normalisation before you get any further with this approach.
Creating multiple tables per month per person for this is a no no.
Search out the chapter posted here by Pat Hartman or wait for the book to reach the shelves.
Search here for posts on the subject, have a look at some of the db's constructed by the wizards for some ideas.

 

[-id-]

Yeah, this db is for my mate and he initially told me what he had done and I quickly took to the forums. I thought about it and tried some stuff, which worked and some that didnt. At school we touched on normalisation.

I redesigned his DB structure so that there were only 2 tables instead of a table for each person.

Thanks for the help though,

ta,
-id-