Hi Jolene!

The code below looks ok, except if you end up at eof of the tmp table. if you are setting on eof() then the replace will not happen.

try it this way...
use your code up to the set relation command
locate
Replace all Gidetail.dnld_stat with 1 for;
Gidetail.sessionkey = Tmp.Sessionkey

* adding the locate statement will force the parent to the top.

>
>Use Gidetail && This is my child table
>Set order to sessionkey && Common field
>
>Select sessionkey from gisum;
> where Upld_stat = 1 into ;
> table o:\Tmp && Tmp will be my parent table
>
>Set Relation to Tmp.sessionkey into Gidetail
>
>Replace all Gidetail.dnld_stat with 1 for;
> Gidetail.sessionkey = Tmp.Sessionkey