10 Replies Latest reply on Feb 23, 2016 1:29 PM by andrewma

    Proper way to copy field contents from one database to another based on a calc.

    andrewma

      I have a field with 20 reps, and lets say I want to copy only 5 of these reps to a corresponding field in a separate database, but in that other database I want to only use the first 5 reps of the field to enter in the 5 lines of data from the other database.

       

      So for example, one field has 20 lines (reps) of data, I want rep# 5, 8, 10, 15, 19  to be copied into the same field in the other database but into rep# 1,2,3,4,5

      This way i don't have blank reps of data for the lines that were not copied.

       

       

      I hope that is made clear.