Updating Fields In One Table From Another in FoxPro
With Microsoft products dropping support for DBF files, I've been using FoxPro 7 much more now.
One of the more annoying things in FoxPro (and maybe other systems) is when you update a DBF field from another, a simple UPDATE query does not work. You need to use:
SET RELATION TO table.field INTO otherTable REPLACE destField WITH otherTable.field FOR table.joinField = otherTable.joinField
This is a fairly annoying way to do it, but it works. Both statements are required.