General information
Title:
Question on appending records
I have two identical tables in different directories. The
data in the first table changes monthly and I will update
the second table from it. I used a set relation statement,
replace field data, etc. I also want to append records from the
first table to the second table when there is no matching
record in the second. I'm considerin a scan..endscand with
an if statement based on a seek on the indexed field. Is
there a better way? Some kind of SQL update maybe?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only