>Cetin,
>
>This doesn't update the modacad table. The path field that is in the paths DBF file should update the path field in the modacad table where the mainkey is the same. I cannot find the ref to the modacad table.
>
>Many Thanks
Right my bug :
SET DEFAULT TO 'C:\Pathproblem'
select paths
local luMainKey
scan
luMainKey = paths.MainKey
update Modacad set path = paths.path ;
where mainkey = m.luMainkey
endscan
Cetin