>How can I do as below ?
>
>Use table2
>
>append from table1 for table1.recno () = table2.recno ()

No, table2.recno() and table2.recno() are illegal calls. Anyway, I suggest that you ignore record numbers except if you work with cursors. If you later want to update your application to a "real" data engine, like SQL server, record numbers simply does not exist. You should ALWAYS have a field in your tables with unique values for each record. It's this unique field that I called uniqid earlier.