Inserting Rows in another table automatically

[Public]

Hi,
I have a table (say Table A) to which I am storing some data. After that, I
want to be able to insert records in another table (say Table B)
automatically (like by clicking a button).
In other words, I want to do is to read records from Table A and based on
some processing store new values in Table B without inserting each and every
value in Table B.

Regards

 

[Evi]

You are describing an Append Query (you can certainly put a button on your
form to run this)
You are also describing something which may be an incorrectly designed
database. The only part of one table which you would *usually* have to copy
into another is the Primary Key number of one table which would be entered
into the Foreign Key field of the other table.
Evi