Well naturellement, as you don't have the table selected. Try:
use table1 in 0
use table2 in 0
select table2
replace field with anothervalue in Table1
Terry
>This behavior continues to vex me
>
>use table1 in 0
>use table2 in 0
>select table2
>replace table1.field with anothervalue
>
>This occassionally fails on me for no apparent consistent reason.
>If you issue a select table1 first as such:
>
>select table1
>replace table1.field with anothervalue
>
>Then Fox never fails to replace the field.
>
>Does anyone have any ideas?
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.