filemaker pro 16 copy all fields from one table to another

Check the functions you want to import.Open the Manage Custom Functions dialog in the target file.

We don’t want to have to fix “” errors in our calculations. We do this now in case custom functions are referenced in calculated fields or script calculations. If there are any custom functions in the source file that do not exist in the target file, copy or import them from the source to the the target file. You don’t want to have to go through each layout and script and fix all of the “” or “” errors manually.Īt this point, you are not copying any fields or tables yet, you simply want to make sure than any of the table occurrences and fields that already exist in your target database match the corresponding table occurrences and fields in the source file (the one you will be throwing away).

This way when you copy scripts and other objects from one file to another, it will properly map the tables and fields. The main idea behind this step is that you want to make sure that the two files have matching table occurrence and field names. Step 1: Rename table occurrences and fields This will insure that any buttons, calculations or other objects that rely on other objects will maintain their links.

Copy Layout Objects and Recreate Layout-Based Script Triggers.

Check Calculated Fields (check the Import.log file or use the Import Log Interpreter tool).

Copy any necessary fields into existing tables.

Rename table occurrences and fields in source file (throwaway file) to match target file.

In general, when copying functionality from one FileMaker file to another, you will want to do so in the following order:

If you have an older version of FileMaker or do not have the Advanced version, you may need to work a little harder.

Note: This article was based on FileMaker Pro 11 Advanced, and the same process still applied for FileMaker Pro 14 Advanced.

Filemaker pro 16 copy all fields from one table to another