Tutorial 201:

Create

Tutorial 201: Lesson 3

Tables, Fields and Relationships

Lesson Materials
Download Files

Building out your data model

Now that you have a clear picture of how your data will be organized, you can start building your app’s structure. You’ll start by creating tables and fields to house your data. When you’re done, you’ll have a basic database: the foundation of your custom app.

When your tables and fields are in place, you’ll learn how to import Excel data into your new tables. FileMaker Pro is great at importing data from other sources. If your format isn’t supported, you can convert it to Excel or another supported format.

Finally you’ll link your tables together by creating relationships. By themselves, tables aren’t much more powerful than spreadsheets, because you can only work with the data from one table at a time — but when you link your tables together, they become aware of each other’s data. After you relate tables together, you can see and understand the connections in your data.

Why is this important?

  • Tables and fields are the base of your app — home to your data.
  • Once you’re comfortable importing data, you can begin to unify information from other areas of your business into one app.
  • You’ll use relationships to group and display related data in much of the work you do in your app in the future, from layout design through to reporting.

Video 1

Creating tables and fields

In this activity you will begin creating a database from the ground up.

In this video, you will:

  • Create tables: set up structures for the things you’re tracking (0:49)
  • Create fields: define the information you store in tables   (1:34)
  • Set field options: enter data automatically in primary key fields (2:08)

Video 2

Importing data into your app

Populate your new tables and fields with information.

In this video, you will:

  • Import data: use the data you’ve already gathered to help you create your app (0:29)
  • Map fields: let FileMaker Pro help you put data where it belongs (1:14)
  • Check your imported data: view your records to make sure they’re what you wanted (2:42)
  • Re-set the serial number: ensure unique values in each new record you create (2:57)

Video 3

Creating relationships

Create your first relationships, then see the results in action.

In this video, you will:

  • Manage relationships: explore the relationship graph (0:10)
  • Create a relationship: link two tables to each other (0:43)
  • View your connections: view related data (1:20)

Related Resource