1 Reply Latest reply on Dec 8, 2012 9:34 AM by davidanders

    Archiving question

    jb362

      Title

      Archiving question

      Post

            

           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?

           Thanks,

           Jerry

        • 1. Re: Archiving question
          davidanders

               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.