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

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.
--
Maurice Ausum


"Leonidas" wrote:

> 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

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

"Maurice" wrote:

> 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.
> --
> Maurice Ausum
>
>
> "Leonidas" wrote:
>
> > 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

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.
--
Maurice Ausum


"Leonidas" wrote:

> I want a table for every supplier.
> But probable I could store all the transactions with suppliers in one table
> as well...
>
> "Maurice" wrote:
>
> > 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.
> > --
> > Maurice Ausum
> >
> >
> > "Leonidas" wrote:
> >
> > > 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

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.

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.
--
Maurice Ausum


"Leonidas" wrote:

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

On Tue, 8 Jan 2008 23:18:00 -0800, Leonidas
<(E-Mail Removed)> wrote:

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