>hi,
>thanks.
>can i make it like uder via form--->inti
>Select mytable name into cursor csrMyCursor moh.

You can have your SQL select wherever you want, in the .Init() if you know at that time what cursor user wants and that he ewants it straight away on entering the form. If your grid doesn't "know" what its control source is, at design time, then you have to set it up programmatically as in my example.

Your example would seem to be fine. It's likely your grid columns won't be the correct width for the table fields in them, and you may want to have nicer column headers, etc.. SO you may have to add the code as below:

     With Thisform.grdVarZoneData
      .FontSize		 = 8
      .RecordSource	 = "CENSUSZN"
      With .Columns(1)
	.FontBold		 = .T.
	.ControlSource	 = "CENSUSZN.ZONE"
	.Header1.Caption	 = "Zone"
	.Header1.FontBold	 = .T.
	.Width		 = 33
	.Bound		 = .F.
	With .text1
	  .ControlSource	 = "ZONE"
	  .Visible	 = .T.
	EndWith
      EndWith

      With .Columns(2)
        ... etc.
      EndWith
    EndWith    && Thisform.grdVarZoneData

>
>you man i must repait all fields ...
>

>With thisform.grdMyGrid
>  .RecordSource = "csrMyCursor"
>  .Column1.ControlSource = "csrMyCursor.Field1"
>  .Column2.ControlSource = "csrMyCursor.Field2"
>  .Column3.ControlSource = "csrMyCursor.Field3"
>  ... etc.
>

>thanks.
>
>
>>>hi all,
>>>
>>>i need to create temperory table, at my form , and build grid via this table.
>>>after save ,drop this table, if i run my form again ,creat it again,
>>>
>>>if this form sharing ,if any user run this form he get deffirent table ,
>>>
>>>thanks.
>>
>>You can create your temp table via Select ... into cursor csrMyCursor .... ReadWrite.
>>
>>Then you can set up your grid by:
>>
>>

>>With thisform.grdMyGrid
>>  .RecordSource = "csrMyCursor"
>>  .Column1.ControlSource = "csrMyCursor.Field1"
>>  ... etc.
>>