>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.

Put xstud in quotes in the seek()