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)