transfer of data

[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.

 

[ajetrumpet]

you have to be more specific if you would like an answer to the problem. also, please do not double post in another forum: http://www.access-programmers.co.uk/forums/showthread.php?t=174421

 

[sazd1]

Thanks for your response.
And sorry for the double post of question. I thought that it may be either related to a Query or a Table. So i posted it to both the forums.
I am working in Vb Express with MsAccess as database.
I am trying to develop a Point of Sale. The data from ListView is transferred to the table Customers with fields CustId,Description,Quantity,Price,Amount. There is another table Transaction which has some common fields of Customer Table. I want that the data of Customer table is updated in Transaction table programatically in MsAccess without any more coding in Vb Express.
I hope i have been able to clear my problem.