Hi John,
if you update to VFP9 (or VFP8 for that matter), you will have a new function XMLUPDATEGRAM( ), which is designed to do exactly what you need. I have seen it done, and I know that it is very easy. However, since I did not need this functionality myself, I did not give the subject enough attention to be able to explain exactly how it is done. But shortly, XMLUPDATEGRAM( ) automatically creates an XML file with all the changes, and this XML file can be sent to the other location where XMLUPDATEGRAM( ) can be used to apply these changes.
>Hi,
>
>I have the same application at two different sites, one in US and the other in Canada, Canada being the headquarters of the same company.
>
>The database, tables, etc. are exact duplicates at both sites. The only differece is that one site is ot allowed to add records to a two tables ... customers.dbf, and products.dbf
>
>When adding a new records to these files, I need to automatically add these records to the same tables at the other site. They have to be an exact match and I would like for a user to be able to update automatically those tables to make sure they are the same. What is the best/simplest way to achieve this? I do not wish just to write over the files ... or is that a good enough solution?
>
>Both networks of both sites are connected via VPN (gateway).
>
>Thanks in advance for your help!
>
>John