Skip to main content
Question

Is there a way to copy fields from one table into another

  • March 29, 2017
  • 0 replies
  • 365 views
I have two separate tables that will have around 100 of the same fields. The tables are separate and the information can not be put into one table due to process and policies. Is there an easy way to copy over fields from one table to the next without having to manually input them twice?_
      This topic has been closed for replies.

      • ChrisChris
      • Registered
      • March 29, 2017
      When you display the report, you should have the "More" menu option at the top right of your screen. When you click, "More", do you not have the option to "copy these records to another table" option?
      Forum|alt.badge.img+14
      • LauraThacker
      • Registered
      • March 29, 2017
      1) Will your second table essentially "duplicate" the first table; but only have certain fields in it?
      2) Will your two tables have the same Key Field if they are not duplicates?
      3) How will you update your second table?  Record by record or in bulk?
      Laura Thacker | laura@intelligentdbs.com | (626) 771 0454
      • MCFNeil
      • Registered
      • March 30, 2017
      2 easy options that I've used to duplicate the table.

      Option 1:
      > If you have one table made already, you can add ALL 100 of those fields to a report.
      > Save that report as a spreadsheet
      > Then use the option to create a new table from a spreadsheet, then it will go through and it will ask you the field types for all of the fields.  
      (With 100 fields that could take some time)

      Option 2: (My preference)
      > Copy your application
      > In the original app, go to the app management settings page
      > Select "Move a table into this App"
      > find the table in your copied app.
      > Transfer
      > Then just rebuild any relationships needed.
      (shouldn't take more than 5 min, and about 20 clicks)
      Terms & ConditionsAccessibility statement