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