I am new to development in FM.
I have a table with several fields. I want to run a script that will step through each record in the table (Loop) and add data from say 3 of the fields to the same fields in a different table.
How does one, in the script, select the second table and add a record in that table allowing one to Set Field in that table replacing the chosen fields with the data from the first table. This script will only be run once ever as it is part of some automation I am building for a user to transform a database but I really want to know how to do this anyway.
Any help will be appreciated