Where to put this "behavior", in start of each form. And, please look the following syntax, is there any changes for VFP9.

SELECT dSiMain.*, dSisUb.icode, dSisUb.Quantity, dSisUb.Rate,;
                  dPCode.pname, dIcode.full_desc, dIcode.maincat, dIcode.category,dIcode.subcat ;
                  FROM dSiMain;
                  RIGHT JOIN dSisUb ON dSiMain.SiNo == dSisUb.SiNo;
                  LEFT JOIN dPCode ON dSiMain.pcode == dPCode.pcode;
                  LEFT JOIN dIcode ON dSisUb.icode  == dIcode.icode;
                  WHERE BETWEEN(dSiMain.DATE, dt1, dt2) ;
                  INTO CURSOR tempsale ORDER BY maincat