dynamically creating tables

[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!!

 

[Duane Hookom]

This is quite an unusual request. Can you share what you are attempting to
accomplish? Maybe provide an example?

 

[Anthony]

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?

 

[Duane Hookom]

That idea would create a highly un-normalized and difficult to maintain
application. Take a look at the table structure in the Northwind sample.