dynamically creating table

  • Thread starter Thread starter Antony
  • Start date Start date
A

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

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