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?
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?
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)