Copying or importing table schemas (FileMaker Pro Advanced)

Contents > Customizing files with FileMaker Pro Advanced > Adding tooltips on layouts (FileMaker Pro Advanced) > Copying or importing table schemas (FileMaker Pro Advanced)

Copying or importing table schemas (FileMaker Pro Advanced)

With FileMaker Pro Advanced, you can consolidate tables from a multi-file solution into one file. There are two methods for consolidating solutions:

Copy table schemas — Open source files to select and copy the tables you want. Then, paste the table schemas into the destination file.

Import table schemas — Import table schemas directly into the destination file. You can import just the schemas or import data with a single schema. (To import the data with a single schema, choose File menu > Import Records > File. See Importing data into an existing file.)

To copy table schema:

1.	Open the database file that contains the table you want to copy.

2.	Choose File menu > Manage > Database > Tables tab.

3.	Select the table you want to copy.

4.	Click Copy.

5.	Open the database file where you want to paste the table.

6.	Choose File menu > Manage > Database > Tables tab.

7.	Click Paste.

To import table schema without data:

1.	Open the database file into which you want to import a table.

2.	Choose File menu > Manage > Database > Tables tab.

3.	Click Import.

4.	In the Open File dialog box, select the source file.

5.	In the Import Tables dialog box, select the tables you want to import from the list and click OK.

6.	In the Import Summary dialog box, click Open Log File to see a more detailed log of the procedure or click OK to close the dialog box.

Notes

You must have full access privileges to the source and destination files.

Privileges from the source file are not retained. You must redefine privilege sets in the destination file.

Relationships between table occurrences are not retained.

If you created fields or tables and want to import them into the same file, close the Manage Database dialog box once before importing.

FileMaker Pro Advanced retains data source references to tables, fields, and scripts if they are valid when you copy or import. Check all data source references after pasting or importing to ensure they are valid.

Open the Import.log file, normally located in the folder with your destination database, for details on unresolved references and items that were renamed due to a naming conflict. If you've opened the destination database remotely or do not have write access to that folder, check the My Documents folder (Windows XP) or Documents folder (Windows Vista, Mac OS).

You must convert database files from versions of FileMaker Pro earlier than 7.0 before importing tables.

FileMaker Pro Advanced may not be available in all of the shipping languages of FileMaker Pro.

Documenting database schemas (FileMaker Pro Advanced)

Importing data into FileMaker Pro

Contents > Customizing files with FileMaker Pro Advanced > Adding tooltips on layouts (FileMaker Pro Advanced) > Copying or importing table schemas (FileMaker Pro Advanced)