dynamically creating tables

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

hi is it possible to create a table first, then after
that each of the new entry in the table will create a
table specifically for that entry? thanks!!
 
This is quite an unusual request. Can you share what you are attempting to
accomplish? Maybe provide an example?
 
I am trying to create an inventory database. I am
thinking of creating only the order table at first and
another table for a more detail description of the order
(this table would only contain the information of an
order, and I am thinking using this table as an
template). Then for each new order I enter into the order
table, access could create a new table by using the
existing template table I created. I hope you guys get
what I am talking about. Thanks!!!!!! If it is feasible,
how would you do it?
 
That idea would create a highly un-normalized and difficult to maintain
application. Take a look at the table structure in the Northwind sample.
 
Back
Top