I have a local SQL Server Compact 3.5 DB that will have 12 tables for the year payments and 12 for receipts.

I have got it working with July's table and am not sure if i will have to maunally make another 23 tables or some how reuse it via code.

Can anyone suggest how to save creating another 11 tables for payments and 12 for receipts?

This database will also need to be copied for the next finacial year when it arrives so i am also trying to work out how to make it a template database and then reload next year as a new blank DB.

thanks
toe