Hi Jay,

See http://www.berezniker.com/display/VFP/Queries+and+Filtered+Cursors

>Getting an error: 'CRSSCHEDULE' must be created with SELECT...INTO TABLE
>
>

>SELECT ;
>	crsSchedule.S_RefProv AS ProvID, ;
>	crsSchedule.S_RefName AS ProvName, ;
>	crsSchedule.S_Pat_Num AS ContactID,
>	crsSchedule.S_Pat_Name AS SchedName, ;
>	crsSchedule.S_Phone AS SchedPhone, ;
>	crsSchedule.S_Date AS SchedDate, ;
>	ALLTRIM(STR(crsSchedule.S_hh)) + ':' + ALLTRIM(STR(crsSchedule.S_mm)) AS SchedTime, ;
>	crsSchedule.S_Off AS LocCode ;
>	FROM crsSchedule ;
>	INTO CURSOR crsApptBox
>