Hi Liam,
In the form.init I put in the following:
FUNCTION justcopydata
SELECT tableX
APPEND BLANK
REPLACE tableX.column1 WITH tableA.column1
REPLACE tableX.column2 WITH tableA.column5
REPLACE tableX.column3 WITH tableA.column6
....
REPLACE tableX.column14 WITH tableB.column5
ENDFUNC

Then when I go to exit out of this screen I get the following error:
"Methods and events cannot contain nested procedures or class definitions." -OK- I am just coping information from a few different tables to the report table (tableX).
Now I want to call this function several times in form.command1.click. Am I putting the local function in the wrong place because I tried putting it in form.command1.click before the rest of my other code and I was still getting that same error? If you need any more info let me know.
Thanks
Justin