Moving Fields & Content from one table to another...
I need to create four new tables from data already existing in one table. What I normally do for this is:
- Duplicate the original table
- Duplicate the pertinent fields
- Duplicate the pertinent layouts
- 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?