 Creating Tables and Fields In the last lesson, you created an Entity Relationship Diagram, or an ERD, representing your clinic's needs. Now you'll use that ERD to start building your custom app in FileMaker Pro, creating the tables and fields that are going to house your data. Begin by creating a new file for your app. If you haven't launched FileMaker Pro, do that now. To create a new file, click File, and choose New Solution. Name your new app Service Tracker. Then choose a place to store the file. Now click Save. The first window you should see is the Manage Database window. If you don't, go to File, Manage, Database. This is where you'll create tables and fields, and later the relationships your app needs. Switch to the Tables tab. FileMaker Pro creates a table using your file name by default. Your first task is to change its name to match the first table in your ERD. Replace Service Tracker with Client in the Table Name field. Then click Change. Now create the other two tables from your ERD. In the table name, type Visit, then click Create. You'll see the table appear in the list. Type Service, and then click Create. You now have all three tables created. Next, you'll create fields for your three tables. Select the Fields tab. Begin by selecting Client from the Table drop-down list. This is where you'll add the fields related to the Client table. You'll need to create a name and select a type for each field. As a best practice, the first field you should create for each table is the Primary Key field. This will be the unique identifier for each Client record. Type Client ID in the Field Name box. In the Type list, choose Number, and then click Create. Now you'll set additional options for the primary key. Click Options. Choose the Serial Number option. This will create a unique number for each record in the Client table. But you can change this to start at any number. You'll be importing some data in the next video, and the primary keys go up to about 90. To avoid overlapping those numbers, set Next Value to 100. That way, any records you create later will have primary keys that are higher than the ones from the import. Turn on Prohibit Modification of Value during data entry. This locks the data in the field so that it can't be changed by users. Click OK. Now create the other fields you need in the Client table. Type First Name, then choose Text from the Type options. Click Create. Repeat these steps to create four more text fields. Last Name, City, Phone, and Email. Next, you'll create a field that can store an image. In the Field Name, type Photo, and choose Container as the field type. Then click Create. A Container field is a special field type that can hold files, like images, documents, audio, and video. Now choose Visit from the table dropdown to create the fields for your Visit table. Start by creating the Visit table's primary key field, called Visit ID. Set the field as a number, and then click Create. Since this is a primary key, click Options. Enable the checkbox for Serial Number, and set the next value as 300. Turn on Prohibit Modification of its value. Click OK. Since the Visit table needs to relate to the Client table, create a foreign key called Client ID. Make the field a number. Click Create. The foreign key will allow each Visit record to tie to its related Client record. Create the Visit Date field, and set it as a date. Click Create, followed by Options. Since a new Visit record is usually created on the same day as the actual visit, you can set the Visit date to default to today's date. Turn on Creation, and click OK. Repeat the field creation process to create the following four fields. Visit Time as a Time field, Therapist as a Text field, Signature as a Container field, and Note as a Text field. For our last table, select Service from the table dropdown. Start by creating the Service table's primary key field, called Service ID. Set the field as a number, and then set its options to Serial number. Set the next value to 500. Turn on Prohibit Modification of its value. Since the Service table needs to relate to the Visit table, create a foreign key called Visit ID. Make the field a number. Now, create these remaining two fields. Service Name as a Text field, and Duration as a Number field. Click OK to close the Manage Database window. With your ERD as a blueprint, you've now successfully created multiple tables and fields for your app. In the next video, you'll import your existing data from spreadsheets into your newly created tables.