Create Table after a record is inserted

[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

 

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

 

[Leonidas]

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

 

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

 

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

 

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

 

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

<SHUDDER>

Absolutely.

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


John W. Vinson [MVP]