You cannot COPY. You isolate the records into a FoundSet in the source table. Go to a layout in the destination file. Initiate a File Import. You have to select the file and then the source table. This is a legacy from pre-VER7. It would be nice if there was a parameter to the import that did so intra-file.
Thanks a lot for your input!
Finally, I opted for a loop where first I set in variables the fields I want to copy in the Forecasted Revenue table and then I set the fields of the Realized Revenue using these same variables.
It took some trial and error to make it work and I am sure my script could be largely optimized but it works! :-)
Import records can be set up to work to copy data from Table A to Table B when both are in the same file. You go through the same steps to specify the source file and table that you do for importing from a different file, you just select the same file that you already have open. You can even do this for an external table if you set up a table occurrence to the source table using an external data source reference.