How to insert data into a duplicate table

i have a table B which is duplicate of table A. when I insert data into A it should also be inserted into Table B. how can we do this???



How big is the table (i.e. number of fields)?

If it is relatively small, then override the insert method on table A; here copy the contents from A to B.

BTW why do you want to maintain duplicate data?

Hi Harish,

I did it by using insert_recordset .