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?