>It all depends on how your doing it. If you use REPLACE table2.field WITH "X" then it doesn't work. If you use REPLACE field IN table2 it does work. I guess becuase the first variant uses the system EOF() which is the current table and the "IN table" variant tests EOF() for the appropriate table.
Wow! I never knew it made a difference! I hate it when VFP help isn't clear! It doesn't make any reference to the different behaviors you described! I just tried it and it worked. I'm happy to know that I no longer have to select certain tables before doing a replace! Thanks a LOT!
Steve.