Select whatever into cursor curtemp && a temp cursor select mycursor && The cursor that drives your grid zap select from (dbf('curtemp')) yourgrid.refresh()>Hi all,
>CrsTempSabt = "_" + SUBSTR(SYS(2015), 4) >>
>CREATE CURSOR &MyCursor (HCode C(14), HName C(100), HADesc C(50), Hnum1 N(12,0), Hnum2 N(12,0)) > > >* Filling MyCursor with Table2 data > > >thisform.grid1.RecordSource = MyCursor >thisform.grid1.column1.ControlSource = "HCode" >thisform.grid1.column2.ControlSource = "HName" >thisform.grid1.column3.ControlSource = "HADesc" > >SELECT &MyCursor >GO TOP >Thisform.grid1.Refresh >>