When I run this command it highlights the IF Seek line and gives mer an error stating:

Alias is not found

I think it is something to do with opening the modacad and paths tables.

Here is my syntax to date:

SET DEFAULT TO 'C:\Pathproblem'
select paths
go top
scan
  if seek(Paths.mainkey,'modacad', 'ModaCadOrderByMainKey')
     replace modacad.paths with paths.path
  endif
endscan

Many Thanks