need to know how to make table template

[trent2275]

I need to know if anyone can tell me in simple language how to make a template for tables in my database. I am making a database and have about 5 tables that I need to replicate over and over with different information inside each table (like changing dates, check numbers, dollar amounts, etc.)

 

[Guest]

Just make the first table, then copy as many as you need.

-----Original Message-----
I need to know if anyone can tell me in simple language

how to make a template for tables in my database. I am
making a database and have about 5 tables that I need to
replicate over and over with different information inside
each table (like changing dates, check numbers, dollar
amounts, etc.)

 

[Kevin3NF]

Sounds like you may actually need a different setup/design.

Having mutiple tables with the exact same structure just screams
"normalize!"

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

I need to know if anyone can tell me in simple language how to make a

template for tables in my database. I am making a database and have about 5
tables that I need to replicate over and over with different information
inside each table (like changing dates, check numbers, dollar amounts, etc.)

 

[John Vinson]

I need to know if anyone can tell me in simple language how to make a template for tables in my database. I am making a database and have about 5 tables that I need to replicate over and over with different information inside each table (like changing dates, check numbers, dollar amounts, etc.)

I agree with Kevin. Storing data in tablenames is EXTREMELY BAD DESIGN
and will get you into endless trouble! If you have different
categories of data, just use ONE set of tables with a category field
to distinguish them, rather than creating new tables!