Automatic Data Transfer from one table to other

[sazd1]

How the data of one table can be automatically transferred to other table in MsAccess?
For example:
How data of TableCustomer(CustId,Description,Quantity,Price,Amount) can be transferred to TableTransaction(TransId,TransDate,AccountId,Description,Quantity, Price,Amount,CustId).
Please guide.

 

[Lister]

You can use an action query, Insert into

Where bla bla bla, or you can code it in VBA using Recordsets. Whats you skill set in Access? Perhaps look into Action Queries, Insert, if you have not had to much time with VBA.