Be aware that SET RELATION does not filter on parent key
Just does an implicit Seek() when recno(parentTable) changes

I would rather do this:

REPLACE in DataEntry OtherField WITH 1 for DataEntry.EmpNumber = Navigation.EmpNumber

>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?