Duplicate an existing table
Only administrators and super-administrators can duplicate an existing.
-
Click on File to go to the backstage section, select Database and click Edit tables of the current database.
-
Select the table to be duplicated from the Table of current database list.
-
Click on the small arrow besides the More button and select Duplicate selected table. A 3 steps wizard will be opened. See wizard explained in Add a new empty table.All the fields of the original table will be present in the new table and equivalency between the fields of the two tables will be automatically established allowing easy exchange of data between the tables and the polyphasic comparisons of records coming from both tables.