Create Table after a record is inserted

L

Leonidas

Hi,

I have a table with the name of all my suppliers. Every time I add a new
supplier I want a table with a standard structure and name of the spesific
supplier to be created.

Is it possible to be done?

Thank you,
Leon
 
M

Maurice

So you want a table for every supplier or you want the suppliertable
constantly duplicated. I don't think that's following the normalization rules
and you might be in a lot of trouble with maintenance on your db.
 
L

Leonidas

I want a table for every supplier.
But probable I could store all the transactions with suppliers in one table
as well...
 
M

Maurice

Your correct on you last comment. Maybe i'm misunderstanding but you should
keep all your suppliers in one table called suppliers and store the
transactions in a seperate table.
 
L

Leonidas

So, you say that is better to have one table with all the suppliers and
another one with all the transactions...and not a separate table for the
transaction of every supplier.
 
M

Maurice

Depends on what you are looking for. It seems that you can have various
transactions and every transaction is done by a certain supplier. In that
case you can add the supplierID to the transaction and you know which
supplier supplied which transaction. In that case you have two tables a
supplier table and a transactiontable.
 
J

John W. Vinson

So, you say that is better to have one table with all the suppliers and
another one with all the transactions...and not a separate table for the
transaction of every supplier.
Click to expand...

<SHUDDER>

Absolutely.

Creating a new table for every instance of an item of data is simply wrong.


John W. Vinson [MVP]
 
Top