SELECT ; RFRefFil.Ref_No, ; RFRefFil.PO_No, ; RFRefFil.Phone1, ; RFRefFil.Phone2, ; RFRefFil.Phone3, ; RFRefFil.Map_Page, ; RFRefFil.City_Area, ; RFRefFil.Shp_City, ; RFRefFil.Shp_State, ; ARCusFil.Cust_Name, ; ARCusFil.Cust_Add1, ; ARCusFil.Cust_City, ; ARCusFil.Cust_State, ; ARCusFil.Cust_Zip, ; ARCusFil.Cust_Phone, ; RFRefFil.LEFT(Instr1,30) AS Instruc1, ; RFRefFil.SUBSTR(Instr1,31,30) AS Instruc1a, ; RFRefFil.LEFT(Instr2,30) AS Instruc2, ; RFRefFil.SUBSTR(Instr2,31,30) AS Instruc2a, ; RFRefFil.LEFT(Instr3,30) AS Instruc3, ; RFRefFil.SUBSTR(Instr3,31,30) AS Instruc3a,; RFRefFil.LEFT(Instr4,30) AS Instruc4, ; RFRefFil.SUBSTR(Instr4,31,30) AS Instruc4a; FROM ; RFRefFil, ; ARCusFil ; WHERE ; RFRefFil.Ref_No=lnRef_No AND ; RFRefFil.Customer=ARCusFil.Customer ; INTO CURSOR tmpRPRTSCR SELECT tmpRPRTSCR REPORT FORM rprtscr PREVIEW REPORT FORM rprtscr TO PRINTER PROMPT