Is there a way to transfer multiple fields from one table to another?
I created a table with a long series of fields but I only realized now that some of these fields would work better if I put them in another table by linking it to the first one. Normally I would know how to do it but in this case is there a way to move more fields to another table by creating ad hoc records and linking them to the source records?
2 replies
-
To permanently move data from one table to another as a one time task, the best way, I think, is to use the Update multiple records function.
First you need data in your new table can match the appropriate record in the old table. Of course you also need the appropriate fields in the new table as well.
Then in your new table at the table view you would select the gear icon and select Update multiple records. For each field you need to copy the data, you would select Assign Calculated Value.
Then you would type in the code that would select the appropriate record from the old table and copy the data from the appropriate field.
Then when the update is done you can delete the fields in the old table as they are now redundant.
Here is more info in another forum.
Content aside
- 1 yr agoLast active
- 2Replies
- 184Views
-
2
Following