Hi Eric,
This is the code I have so far:

close table all
use student in 0
use xstud in 0

select student
scan
    if seek(student.cstud_key,xstud)
        replace student.cstud_id with xstud.cstud_id
    endif
    select student
endscan

When I run it, the program errors out with "Variable 'xstud' is not found."


xstud is a table in my database. I defined a one-to-one relationship between student and xstud on cstud_key. Both tables have a primary cstud_key key and the cstud_id field. I am trying to update the student table with the value in the xstud table using a matching cstud_key.