Yes this is correct. You won't see the revisedapps table in your datasession. You don't even need to, actually.

>Thanks Randy. I placed the code after the IF Block, but noticed that the table "revisedapps" did not show up in the datasession window.
>
>I even tried placed the code right after completing the select statement which is as follows:
>
>

select * from changedappointments into cursor changedappsinfo nofilter;
>	where changedappointments.datechange >= mrepbegindate .AND. ;
>	changedappointments.datechange <= mrependdate  ;
>	group by changedappointments.localdoc,changedappointments.pat_name ;
>	order by changedappointments.localdoc, changedappointments.pat_name
>        COPY TO revisedapps TYPE FOX2X

>
>The above code is just one part of the if/else condition. Am I doing this right? Thanks for your help.
>
>- Ravi