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.