I have users with a local copy of a database on their laptop machines. When they want to copy new/changed records to the master database (Network connection), they select a checkbox when viewing those records. The next time they are connected to the master database, they run a replication function which looks like this:

scan for a record with replication = .t.
search the master database for a matching record
IF the record does not already exist in the master
Append from the local database
ELSE
SCATTER the local record
GATHER to the master record
ENDIF
endscan

While this does work, it seems pretty slow. Is there a better way to do such a thing?

Thanks,
Pat