
In the beginning there were the fields.
Even though FileMaker really doesn't have much to do with the agricultural revolution - nothing at all, to be precise - fields are still the basis of every database, including a FileMaker database. Every database consists of a number of fields that can store a wide variety of data. You are probably already familiar with data fields - every form on the Internet in which you can enter your delivery address in an online store, for example, contains corresponding fields in which you enter the data before submitting the form. The data you enter is stored in a database after it has been sent. FileMaker distinguishes between several different field types in order to be able to store different types of data:
- Text fieldStores alphanumeric text, almost unlimited length in FileMaker
- Number fieldStores any numbers and allows corresponding field calculations
- Date field: Saves a date in the correct date format
- Time field: Saves a time in the correct format
- Timestamp: Saves the date and time within a field
- Media fieldStores any media such as images, PDF files, movies, etc. in a media container
- Formula fieldContains a formula in the definition, the result is displayed in the formula field
- Statistics fieldAutomatically calculated statistics of another field, e.g. "highest sales price"
All fields of a FileMaker database are stored in the database administration under
File > Manage > Database
created and managed. And this brings us to the practical part of this FileMaker introduction. In the course of this introduction, we will create a small address database that can store several (any number of) contact persons and notes per address.
Creating a new FileMaker database
If you already have FileMaker installed on your computer, start FileMaker Pro now. If you do not yet have a FileMaker license, you can download a demo version from the FileMaker website. To do this, click on this website of FileMaker Pro, simply click on "Test now", enter your data in the data fields (yes, we've already done that above with the field types...) and download the software. Once you have downloaded and installed FileMaker, start FileMaker Pro. Once the program has been started, the "FileMaker Quick Start" dialog will appear:
To create a new database, click on "Create new database" in the top left-hand corner of this dialog. A file selection box will then appear in which you can specify the desired storage location and a name for your new database. As we want to save addresses in our database, it is best to name the new database "Addresses.fp7" and then click on the [Save] button. A short time later, a window will open with your new database, which does not yet contain any fields:
Creating new fields in the "Addresses" table
In the new FileMaker 11, it would now be possible to create new fields for your database directly in this window. For the sake of clarity, however, we do not do this directly in this window, but call up the database administration under the following menu item:
File > Manage > Database
This opens the database administration, where you can manage fields, tables and relationships:
To create a new field, simply enter the desired name for your field in the [Field name] field. In the [Type] field, specify what type of data your new field should store. In the comment field you can enter any comment for you as the developer for the field. We require the following fields for our address database:
- Name [Text]
- First name [Text]
- Street [Text]
- House no. [Text]
- Country [Text]
- Zip code [Text]
- Location [Text]
- Phone [Text]
- Fax [Text]
- EMail [Text]
In practice, all of the above fields contain data in text form and should therefore be created as text fields. Now enter the specified field name for each field under [Field name], add a comment if necessary and click on [Create]. So that we can really assign an address uniquely, we also need a key field that has a unique value for each address. We call this field _Address_No and create it as the field type "Number". The underscore in front of the name "Address_No" serves to recognize this field as a unique key field. The advantage here is that fields with an underscore are at the top when the fields are sorted by field name in this dialog. If you have created the field <> and then clicked once on the "Field name" heading to sort, your field definition should look like this:
Finally, we now want FileMaker to automatically generate the unique key for the <> field. To do this, double-click the <> field or click it once and then click the [Options] button. In the following dialog, select the option [Consecutive number] and click [OK]. The <> field is now automatically filled with a consecutive number when a data record is created in your database, which is then unique for each data record.
Create new table for notes
When you created the database that you named "Addresses", FileMaker automatically created a Table which also has the name "Addresses". What is a table? A FileMaker database can consist of any number of tables, each of which contains individual data fields. The fields you have just created are in the "Addresses" table, so they also match the name of the table thematically. If you now want to be able to create any number of notes for each address, you need another table that contains the notes for the address. To create a new table in your database, click on the [Tables] tab at the top. You will now see the first table "Addresses", which should contain 11 fields and 0 data records. To create a new table for the notes, enter "Notes" in the "Table name" field and click on [Create]. The table definition of your database should now look like this:
Now you need to create the fields for your notes in the newly created table. To do this, click on the [Fields] tab again and create the following data fields as in the first table:
- _Address_No [number]
- Date [Date, automatic entry of the creation date]
- Time [Time, automatic entry of creation time]
- Processor [Text, automatic entry of the account name on creation]
- Note [Text]
In this table, the <
> field does not need to contain an automatically sequential number, as this is already assigned in the "Addresses" table. So that you do not have to maintain the date and the person responsible manually each time in a note, add the corresponding option to the <> and <> fields so that the data is inserted automatically.Linking the "Addresses" table with the "Notes" table
So that any number of notes per address can be saved in the new database in future and these can be assigned to an address, we now need to create a relationship between the [Addresses] table and the [Notes] table. To create a 1:n relationship (one address data record : several note data records) between two tables, we need a unique key field in both tables, in our case it is the <> field. To set up the relationship, click on the [Relationships] tab at the top of the database administration. Both created tables and their fields are now displayed in this dialog. To create a relationship between the [Addresses] and [Notes] tables via the key field <
>, simply click on the <> field in the original [Addresses] table and drag it to the corresponding field in the [Notes] table while holding down the mouse button. The relationship graph of your new FileMaker solution should now look like this:Now double-click on the [=] symbol between the two tables. A dialog will now open in which you can specify the relationship options for the selected relationship. As you want to create a note directly in your address later, you must instruct FileMaker to allow the creation of data records in the "Notes" table via the relationship. To do this, select the following option under the "Notes" table:
By clicking on the [OK] button, all changes to the database definition are now saved and FileMaker automatically creates two layouts containing the fields of the two newly created tables "Addresses" and "Notes".
Customize the form layout to your own needs
By default, the two layouts are displayed in "Table view" mode, which is similar to the display of an Excel table. Switch to the Form view you can change the view in the menu bar under:
View > Show as form
At the end of the second part of the introduction, we now want to adapt the form layout so that both the address and the associated notes are displayed in the same layout in a Portal be displayed. In order to Layout mode select the following item in the menu bar:
View > Layout mode
In the layout mode of FileMaker, the Function bar - Now layout-specific buttons are displayed, such as for creating a new layout, adding text, lines, squares, rounded squares, circles, fields, buttons, etc:
When a field is clicked, the Inspector-window displays all options that can be set in connection with the selected field, such as the position, display, text alignment, field input or data formatting for date, number or time fields. If you want to select several fields at the same time in layout mode, simply draw a frame around the desired fields as in the Finder. This is exactly what we want to do now and color all fields on the layout grey. To do this, draw a frame around all fields, but not around the label texts. When all the fields are selected, recognizable by the handle marks at the edge of the fields, click on the [Appearance] tab at the top of the inspector. Now select a light shade of grey in the "Fill" area - the selected fields are now colored light grey.
Adding a portal for the "Notes" table
As the last step of this second part of the FileMaker introduction, we now add a portal (Excerpt) on the layout in which the associated notes for the address called up are displayed. To add the portal, click on the "Section tool" layout tool in layout mode. This is located to the left of the diagram tool. Now use the mouse to draw a frame within which the new section is to be added. The following dialog box then appears:
In this dialog, you can specify from which table the related data records should be displayed (in our case from "Notes"), whether the data records should be sorted within the section, you can filter the display of the related data records according to certain criteria, allow the deletion of related data records, add a scroll bar and configure the number of rows in the section. For our example file, I have set the sorting function by date - descending. After clicking on the [OK] button, another dialog appears in which you can select the fields to be displayed from the Reference table can specify. Select all fields here except for the key field <>.
Once you have selected the fields, click on the [OK] button. Your new section will now be created in your layout at the point where you have drawn the frame for your section. You can now move and arrange the fields on the layout as you wish. Feel free to play around with the layout tools and add a caption text for the note section, for example. In my version of the introductory database, I have moved the fields on the layout a little more appropriately and changed the portal for slightly larger notes so that the database now looks like this:
Congratulations! You may now have created your first FileMaker database that you can use to store addresses and associated notes. If you are interested, I recommend that you also take a look at the FileMaker manual, which explains the functionality of FileMaker very clearly. In the next third part of the FileMaker introduction, I will show you how to add functions and buttons to your database and introduce you to the world of FileMaker scripts. Until then, I wish you lots of fun and success with FileMaker!
FileMaker training and coaching from goFileMaker
Would you like to delve deeper into the subject of FileMaker database development or do you already have your own FileMaker solution that you would like to develop further? With our coaching and training services, we are happy to help you with the development of FileMaker databases nationwide via telephone and remote maintenance. We will be happy to discuss your individual requirements in a personal meeting. To book a FileMaker coaching session, you can simply order the desired number of hours in our online store and let us know your preferred date in the order comment. We are also happy to advise you in advance by e-mail at info@gofilemaker.de.
You can download the sample database of this FileMaker introduction here:
All previous parts of the introduction FileMaker
Part 1: Historical background and versions
Part 2: Practical part with creation of an address database
Part 3: Layouts, navigation, buttons, QR codes
Part 4: Fields and formulas, relationships, scripts, custom functions, plugins, SQL

Markus Schall has been developing individual databases, interfaces and business applications based on Claris FileMaker since 1994. He is a Claris partner, FMM Award winner 2011 and developer of the ERP software gFM-Business. He is also a book author and founder of the M. Schall Publishers.













Great, and what if the table is linked via two links? Right, then the whole thing no longer works because you can only scroll through data records in the first link table.
@Sabine: In what way via two links? The sample database is structured so that you can only scroll through the first (master) table. All notes assigned to the current data record are then displayed in the portal.
mmhhh, everything still looks as it should in layout mode, but when I leave the mode, many things are no longer displayed. I can't even find the pale one in comparison with the example file. What could be the problem? Could I send a screenshot and get a tip?
Hello Heidi! Sure, go ahead, send a screenshot to webmaster@gofilemaker.de send.
Hello Markus
I have to say that it is the best guide I have found after several days in the wide world. http://www.. have found. So I imagine tutorial, for absolute borrowing. thank you very much for your work.
hello, I am a FM 13 beginner...
I have now copied all of this.
But I can only enter one note - I cannot open or connect a second note window on the address layout.
I can enter additional data records on the note layout, but they are not visible on the address layout.....(sometimes the windows are fragmented???)
In my case, only the fields are named differently, but the meaning is the same.
Maybe I could get a tip there.
LG Walter
Hello Walter,
Have you downloaded the sample file? Everything should work as described there, and it will probably also show you if there is still an error in your database.
Hello Markus,
I changed the formatting after creating it, so it didn't work for me.
Created heu again, now it works as described.
Thank you very much!
Hello, I am working with the current filemaker pro version and I am a beginner. I also have the above problem: In layout mode all fields are in the correct position. When I leave the layout mode, some fields move up/down/right/left. What is the reason for this?
Hello, that sounds a bit strange at first. In which area (data area, header area, etc.) did you store the fields?