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

1. You need to be in the work area of the parent table before you SET RELATION. Issue SELECT Reg_Main after you USE it. USE... IN 0 opens the table in the first available work area, without selecting that table/work area. You should also use an ALIAS on the second table to make it easier to work with.

USE reg_main IN 0 ORDER registr_id
pcSport0 = "reg_"+gen_sc
USE &pcSport0 ALIAS MyAlias IN 0 ORDER registr_id
SELECT Reg_Main
SET RELATION TO registr_id into MyAlias

2. Can't help you here, I still use VFP5.