Insert all tables records in another tables

[calexandru]

Hello guys, i work at an ms access, and i need to make a table that is updated from all others tables.

I have 20 tables. Table structure is like this: (table name 1001) Also the tables are the same, with same structure, only the name of table is change from a table to another

ID_1001
Date_1001prop
Name_1001prop
Value_1001prop
Date_1001ang
Name_1001ang
Value_1001ang
Date_1001ord
Name_1001ord
Value_1001ord

Tables names are 1001, 100101, 100102 ..etc

I need to do a table (principal table ) that will looks like this:

ID DATE NAME VALUE
1 date_1001prop name_1001prop value_1001prop
2 date_1001ord name_1001ord value_1001ord
3 date_100101prop name_100101prop value_100101prop

Etc.

A little description in words... when i insert a record in a table .. i need to make an autoregistration, in the separate table. No matter in which table i make a record ... registration should automatically go in the principal table.

Sorry for my bad english. I try to make a little query... a big report... but without success.

 

[dcb]

A little description in words... when i insert a record in a table .. i need to make an autoregistration, in the separate table. No matter in which table i make a record ... registration should automatically go in the principal table.

Access does not currently allow triggers however you could simply do a insert into query whenever you want to insert into your primary table.....

I am trying not to ask the other question......

 

[dcb]

I have to ask the other question .....
What the hell are you doing with alll those tables???

 

[calexandru]

)) It's very complicate... each table is a budget article for payements ot public institutions... I can't explain that in english sorry... but i need to do this

can you help me with that query that you talk?

 

[Atomic Shrimp]

If your tables are all the same structure and you want them all together, you'd be much better off creating a UNION query, because the query results will automatically contain the latest data whenever it is run.

But your problem here is really caused by the design of the database - it desperately needs to be normalized.