Randall,
I would focus on having MySQL as the master DB then updating the other VFP tables from it.
I have to assume from what you say that all the tables, including MySQL contain indentical record sets. If that is the case then IMHO I suggest you have an update process that first updates MySQL then, at timed intervals, have VFP updated from MySQL. If you store the key of the current MySQL record each time the VFP update is done then it would be easy to have MySQL only send the latest records to each VFP table. The key sould be stored locally on each PC.
You could have a seperate VFP EXE on each PC with a timer that runs the update.
It is very important that there only be one Master Database.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn