I have created a student database, and I want to copy a student's record to and alumni table after they graduate before deleting them from the student table.
With no luck, I've created variables in a script for each field and then I go to the alumni table, create a new record and set field using the variable. I can't get it to work...what am I doing wrong? I have tried both "$" and "$$" on the variables.
Thanks for your help!