text: 2 tables. both have same attributes. (s.no, name, etc). i want that when i entered sno. in 2nd table? 2 tables. both have same attributes. (s.no, name, etc). i am entering records in table 1. i want that when i entered sno. in 2nd table, all other attributes of that record from table 1 comes into table 2. another question: i have designed a form named goto whose function is to go to the record which i have entered. please reply me as soon as possible. 1. simply repeat the code to insert twice, using the same info. unless what you mean is you want to get the identity key for the record out of the first table and put that in the second table, in which case, you need to tell me what database you are using.  2. you just need a key to find the record you want: select * from table where record_key = 'some input"