>Barbara,
>We have gotten the sql code to work ok but when we issue grid1.recordsource="hftemp" all of the formating and the column widths of the grid are reset to the default in the table. We tried to use the grid1.columns(1).controlsource="hftemp.rn" with no luck. It sayed "member columns not found".
>
>Please Help
>
>~Quinn

Sometimes you will have to re-establish the columns and headers. The following is code from Jim Booth:

THISFORM.LockScreen = .T.
  THISFORM.Grid1.RecordSource = ""
  * Now do yor things with the select stuff

  * Now fix the grid
  WITH THISFORM.Grid1
      .RecordSource = "Whatever"
      .RecordSourceType = 1
      .ColumnCount = 3
      .Column1.Header.Caption = "Blah"
      .Column1.ControlSource = "Blah
      ...
  ENDWITH
  THISFORM.LockScreen = .F.

HTH
Barbara