AnsweredAssumed Answered

Moving Fields

Question asked by BradWieland on Nov 26, 2012
Latest reply on Nov 26, 2012 by philmodjunk

Title

Moving Fields & Content from one table to another...

Post

     I need to create four new tables from data already existing in one table. What I normally do for this is:

         
  1.           Duplicate the original table
  2.      
  3.           Duplicate the pertinent fields
  4.      
  5.           Duplicate the pertinent layouts
  6.      
  7.           Import the data

      

I do not want this data to be created through a relationship  or a portal between the tables. Each of the four new tables needs to be independent.

     My system (flawed though it may be) works, except that I need to spend considerable time manually switching each field (in my new layout) so that they are showing records from the new table (rather than referencing the old table: Yellow dots instead of Green dots.)

     Is there a way to make all the duplicated fields in the new layouts/tables be native to the new table automatically?

Outcomes