Hi Lincoln,

If the table structures are identical, you could use the

APPEND FROM

command insert all records from one table to another. If they aren't then you will have to add code to compare the structues and add the necessary fields dynamically and then use the APPEND FROM.


>>Can you explain it clearer ?
>
>I'll try. Say I have a table ,"Table1", that is identical in structure (same name/number of fields, same types of data) to another table, "Table2". Table1 has several fields with more recent data than Table2. I want to copy the updated data from "Table1" into "Table2". How do I do this?
>
>Any clearer?
>
>--lincoln