need to know how to make table template

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.)
 
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
Click to expand...
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.)
 
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

trent2275 said:
I need to know if anyone can tell me in simple language how to make a
Click to expand...
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 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.)
Click to expand...

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!
 
Back
Top