Table

What is a table in FileMaker?

In FileMaker, a table is used to store data in any number of fields. You can create as many tables as you want in a FileMaker database. The creation of new tables is done under the menu command [Store > Manage > Database] under the tab [Tables].

Manage database - tables

Add new table

To add a new table, enter any unique name for the new table in the [Table name] field and click the [Create] button. This will create a new empty table with the name you entered. By double-clicking on an entry, the dialog switches to the [Fields] tab to create new fields for the table.

Copy existing table

If you want to copy an existing table, select the entry to be copied with the mouse and then click the [Copy] button. Then click the [Paste] button to insert a copy of the table.

Import table

You can also use this dialog to import tables from another FileMaker file. To do this, click the [Import…] button, then select the FileMaker file from which the table is to be imported.

Import tables from another file

Select all tables from the external FileMaker file you want to import. Click the [OK] button to start importing the selected tables.

Delete table

To delete one or more tables from a FileMaker database, select the table(s) you want to remove, then click the [Delete] button. The selected tables are deleted from the database after a new query.

Related entries

Diesen Beitrag bewerten:

About Author

Markus Schall
Development of FileMaker databases since 1994, modification and extension of FileMaker solutions, conversion of FileMaker databases from .fm, .fp3, .fp5 (FileMaker 2-6) or .fp7 (FileMaker 7-11) to .fmp12 (FileMaker 12-17), interfaces to third-party systems such as online shops, CMS or other databases. Development of individual FileMaker database systems based on the gFM business framework with personal advice from Oldenburg. Operator of the online specialist portal goFileMaker.de, developer of the CRM and merchandise management system gFM-Business. Member of FileMaker Business Alliance, FileMaker Developers Subscription and FMM Expert. Winner of an FMM Award 2011, awarded by the FileMaker Magazine.