Hi,
>and compare OLDVALs with CURVALs (both are VFP unctions special for this). When you encounter differense, AND when user changed value locally - ask about overwrite. When user not change value, replace value in currect reccord by
Just finished testing a proceedure based on the method you suggested. I works great! Thanks. Was stuck for a bit on finding the number of fields in the table without hardcoding it. Ended up with
mnTotFields=Len(SUBSTR(GETFLDSTATE(-1,"Students"),2))
FOR mnHitPoint=1 to mnTotFields &&Check Each Field
SELECT students
fieldname=field(mnHitPoint)
IF &fieldname==OLDVAL(FIELD(mnHitPoint)) &&This user hasn't changed it
And so on! I have a customer that will be very happy.
Thanks again,
Bill
Bill Leber