I'm running into two problems that don't make sense. I'm working in VFP6 with a database designed under FPW26 consisting of free tables.
The database has one main table and about 15 child tables, of which no more than three have any data linked to a record in the master. The main table contains fields with values that can be used to select the necessary child table(s).

1. I'm trying to link one table to a main table with the following:

USE reg_main IN 0 ORDER registr_id
pcSport0 = "reg_"+gen_sc && Identify and open main sport table
&& If gen_sc contains "FB", then
&& pcSport0 becomes "reg_FB"
&& which is the table needed
USE &pcSport0 IN 0 ORDER registr_id && use reg_FB
SET RELATION TO registr_id into &pcsport0 && link reg_main to reg_fb
SET SKIP TO reg_main

The problem is that the SET RELATION instruction halts, saying "Table has no index set". Both tables are indexed on registr_id. What am I doing wrong?

2. With Set Step ON, if I make a minor change to the code, the next time I run the program the Trace window says "Source is out of date". I can't seem to get it to run even by saving the code and shutting down VFP. There is no reference to that error message that I can find anywhere in the docs. How can I clear it?

Thanks,
Neil Preston

I'm on a super hot project with a looming deadline. Murphy thrives under these conditions.