dynamically creating table

[Antony]

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

 

[Joe Fallon]

Probably.
But why?
What are you trying to accomplish?

 

[Guest]

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?

 

[TC]

You need to read:

http://support.microsoft.com/support/kb/articles/Q100139.ASP

HTH
TC

 

[Joe Fallon]

Not a good plan.
You should design the correct table structure once and then simply add
records to the appropriate tables.

Get some advice on how to design a relational database.
It will be worth the effort in the end.

 

[John Vinson]

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.

This isn't how Access is designed to work. You don't store data in
*tablenames* - you store data in *tables*.

You need only an Order table, and an OrderDetails table to accomplish
this. You would have a one to many relationship between the tables -
the OrderDetails table would have as many records for each order as
there are details.

See the Northwind sample database for an example of how this can work.