>>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?
>
>This should work, but I never tried it with filters. Perhaps if you omit filters and do just
>
>replace dataentry.OtherField with 1 for navigation.myfield=1 and dataentry.myfield=100
Now that I read the rest of the messages I realize that this should have been the correct way to do it. I was only scared to try it because I was working in production database, but logic tells me that this is the solution.
Christian Isberner
Software Consultant