I want to archive Table 1’s records into Table 2.
So is this the preferred scenario or is there a better procedure?
1. Starting from Layout 1 move the fields from Table 1 into local variables.
2. Switch to Layout 2 and move the local variables into the fields of Table 2.
3. Switch back to Layout 1 and continue for each record in Table 1?
That is an option.
Table one is the same structure of Table two? The data is sorta duplicated? Maybe look at the first 5 links here.
Another Option Duplicate the database "MyData", rename the duplicate "MyArchive".
Create a script, that imports the found set into "MyArchive", deletes the found set.