query generate data into table (1 Viewer)

[qaccess]

I create a query from different tables. With an website based insert statement I put the data from this query to another table.

Is it possible to fill the table without the insert statement. But automatic done by the database itself. So insert/update all the query data automatic into the table

ThanXs

 

[qaccess]

append query

I found out that you can do it with append query. Is there also to do this automatic?