In a FoxPro 2.6 application, I need to replace fields by using a relation. I thought it should work, but it doesn't.

USE Navigation
SET FILTER TO MyField = 1

USE Dataentry
SET FILTER TO MyField = 100
SET ORDER TO EmpNumber

SELECT Navigation
SET RELATION TO EmpNumber INTO Dataentry
REPLACE ALL DataEntry.OtherField WITH 1

Strange thing, it does not have any effect. Maybe I'm missing something?