Not quite clear how do you define Grid.RecordSource, but anyway, try this:
In form.INIT
with this.Grid1
lccom="YOUR Select statement go here as a plain string without ; and with the clause into cursor tmpcurs or other appropriate cursor name"
.RecordSourceType=4
.RecordSource=lccom
.Refresh
endwith

>hi everybody
>
>i am trying to have a grid with

.recordsourcetype = 4 && sql

. in the erference it states that the sql statment is to be entered in the .recordsource property. i have tryed and must be doing something wrong, because i am getting the error:"Syntax Error", however, in the command window this command is working. here is the sql statement i have entered:
>

>sele ;
>   receipts.item, ;
>   receipts.pono, ;
>   receipts.qtyrcd, ;
>   podet.qtyord ;
>   from receipts, podet, pomast ;
>   where ;
>      receipts.pono = pomast.pono .and. ;
>      receipts.pono = podet.pono .and. ;
>      receipts.item = podet.item
>

>i have no clue what i am doing wrong, can anyone put me on the right path.
>
>thanks in advance (i work with Vfp 6.0 Sp 5)