[General] How could it work?

Suppose you have tables like this:
  table_1                tmp_store              tmp_article
+---------+----------+ +---------+----------+ +---------+----------+
| name    | type     | | name    | type     | | name    | type     |
+---------+----------+ +---------+----------+ +---------+----------+
| dat     | date     | | dat     | date     | | dat     | date     |
| store   | char     | | article | char     | | store   | char     |
| article | char     | | price   | money    | | price   | money    |
| price   | money    | | amount  | smallint | | amount  | smallint |
| amount  | smallint | +---------+----------+ +---------+----------+
+---------+----------+

and an insert like this:
insert into table_1 values ( '08/04/2002', 'aldi', 'hmilch', 0.57, 3 );

Is it possible for each insert
1. verify if a table exists with the name of the (store|article)
   if yes
       a. insert the relevant data
   if no
       a. create a table (store|article) like (tmp_store|tmp_article)
       b. insert the relevant data

I was reading about triggers and functions, but I havn't found an answer
how to create tables in triggers or in functions.

Markus

--
There is no spam like no spam..