Click ok to exit the “Manage Database for Contacts”. That value of one (1) is the serial number for John Doe’s record. Create a new contact record using your own information or feel free to use the information presented in Figure 1.1.įigure 1.4: Options for Field-Validation Tab OptionsĬlick ok to exit the Options for Field window. Note that we have created a new record for John Doe and the associated CONTACT ID MATCHING FIELD was automatically assigned a value of 1. 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.
Starter Files (if you would like to follow along).Familiarity with the FileMaker interface.
We recommend you know the following to get the most out of this week’s post. These function posts are targeted to our beginner FileMaker friends, but anyone interested in refreshing their knowledge on the various functions of FileMaker can benefit from this series. We have decided to turn this into a series that will post on a bi-weekly basis. You may have previously seen our blog posts that focused on reviewing FileMaker Pro functions. FileMaker Pro Function Review-Auto-Enter Serial Number
0 kommentar(er)
