Hi, I have 2 tables custtable,custduplicate. cust table with fields accno,name,etc… custduplicate table with fields accno,name… when i am entering data in the cust table accno,name it has to be updated into the custduplicate table. how can i do that? thanks anish

There are three methods insert, update and delete methods which can be overrided or may already overrided in custtable. By this u can duplicate it in another table

hi, you can use maps or recordset

recordset apply all the record from one table to other table

mapping both the fields (all fields) from those tables .

you can insert cust table then it automatically inserts into duplicate

thanks & regards