
The Contact ID Matching Field can be located in Figure 1.1: Starter File above the Title field on the layout. You may place it anywhere.įor this post, I applied Conditional Formatting to make the field appear red for easier identification. This field already exists in the Contacts database and is called Contact ID Matching Field. In the Contacts solution, I have added a field to the Contact Details layout.

This is also referred to as a flat database file. *FYI: This starter contact solution has only one (1) table. (File > New from Starter Solution… > Contacts) The starter solution I have chosen for this post can be accessed from the menu bar. Let’s get startedįileMaker Pro and FileMaker Pro Advanced come with the option to create a new database from a “Starter Solution”. For example, in this post we use serial numbers to identify each one of our Contacts entered into our Contact Details layout. This is primarily used for creating a primary key-a value that uniquely identifies each record-for that table.


About: Serial NumbersįileMaker Pro can insert a serial number into a field each time a new record is created or committed. In this blog post, we review the option to set up a field with a serial number. It is useful for certain fields to be automatically populated with default data when a user creates a new record.

